software

I am trying to use the formula =Sumif(B7:B203,quot;Paul
Gquot;,(COUNTIF(C7:C203,quot;*quot;))) to count the number of cells in the quot;Cquot; column
which contains text and are in the same row next to my name in the quot;Bquot;
column. This formula does not work. Ay suggestions?

Thank you, paul

=SUMPRODUCT(--(B7:B203=quot;Paulquot;),--(ISTEXT(C7:C203)))

note that if you have formulas in C that can return a quot;quot; (blank looking
cell) they will be included, then you can use

=SUMPRODUCT(--(B7:B203=quot;Paulquot;),--(ISTEXT(C7:C203)),--(LEN(C7:C203)gt;0))

and of course if you only want to test for non empty cells in C

=SUMPRODUCT(--(B7:B203=quot;Paulquot;),--(C7:C203lt;gt;quot;quot;))

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

quot;paulgallanterquot; gt; wrote in message
...
gt;I am trying to use the formula =Sumif(B7:B203,quot;Paul
gt; Gquot;,(COUNTIF(C7:C203,quot;*quot;))) to count the number of cells in the quot;Cquot; column
gt; which contains text and are in the same row next to my name in the quot;Bquot;
gt; column. This formula does not work. Ay suggestions?
gt;
gt; Thank you, paulEither:

=SUMPRODUCT(--($B$7:$B$203=quot;Paul Gquot;),--ISTEXT($C$7:$C$203))

Or:

=SUM(IF($B$7:$B$203=quot;Paul Gquot;,ISTEXT($C$7:$C$203) 0))

which needs to be confirmed with control shift enter, not just with enter.

paulgallanter wrote:
gt; I am trying to use the formula =Sumif(B7:B203,quot;Paul
gt; Gquot;,(COUNTIF(C7:C203,quot;*quot;))) to count the number of cells in the quot;Cquot; column
gt; which contains text and are in the same row next to my name in the quot;Bquot;
gt; column. This formula does not work. Ay suggestions?
gt;
gt; Thank you, paul


hi!

something like

=SUMPRODUCT(--(B7:B203=quot;PAULquot;),--(C7:C203=quot;*text you wanted*quot;))

-via135

paulgallanter Wrote:
gt; I am trying to use the formula =Sumif(B7:B203,quot;Paul
gt; Gquot;,(COUNTIF(C7:C203,quot;*quot;))) to count the number of cells in the quot;Cquot;
gt; column
gt; which contains text and are in the same row next to my name in the quot;Bquot;
gt; column. This formula does not work. Ay suggestions?
gt;
gt; Thank you, paul--
via135
------------------------------------------------------------------------
via135's Profile: www.excelforum.com/member.php...oamp;userid=26725
View this thread: www.excelforum.com/showthread...hreadid=531351Hi Paul,

Try these:

=SUMPRODUCT(--(B7:B203=quot;Paul Gquot;),--(C7:C203lt;gt;quot;quot;))
=SUMPRODUCT((B7:B203=quot;Paul Gquot;)*(C7:C203lt;gt;quot;quot;))

or if apart from non-empty the value in column [C] must be text...

=SUMPRODUCT(--(B7:B203=quot;Paul Gquot;),--ISTEXT(C7:C203))
=SUMPRODUCT((B7:B203=quot;Paul Gquot;)*ISTEXT(C7:C203))

Regards,
KL

quot;paulgallanterquot; gt; wrote in message ...
gt;I am trying to use the formula =Sumif(B7:B203,quot;Paul
gt; Gquot;,(COUNTIF(C7:C203,quot;*quot;))) to count the number of cells in the quot;Cquot; column
gt; which contains text and are in the same row next to my name in the quot;Bquot;
gt; column. This formula does not work. Ay suggestions?
gt;
gt; Thank you, paul

Try
=SUMPRODUCT(--(A1:A100=quot;Paul Gquot;),--(ISTEXT(B1:B100)))
Regards,
Alan.
quot;paulgallanterquot; gt; wrote in message
...
gt;I am trying to use the formula =Sumif(B7:B203,quot;Paul
gt; Gquot;,(COUNTIF(C7:C203,quot;*quot;))) to count the number of cells in the quot;Cquot; column
gt; which contains text and are in the same row next to my name in the quot;Bquot;
gt; column. This formula does not work. Ay suggestions?
gt;
gt; Thank you, paul