formula help please

Susan · Aug 3, 2003

How can I add a row of codes?
Ex: row of cells contains 3 diff codes, pp,vd and sd.
i need to add the number of pp codes, the number of vd
codes and number of sd codes. separate totals in cells.
Thanks for your help

Leo Heuser · Aug 3, 2003

Susan

Check out the SUMIF() -function.
E.g.:
=SUMIF(A2:L2, "pp")

--
Best Regards
Leo Heuser
MVP Excel

Followup to newsgroup only please.

Tom Ogilvy · Aug 3, 2003

=countif(1:1,"pp")

=countif(1:1,"vd")

=countif(1:1,"sd")

Regards,
Tom Ogilvy

Tom Ogilvy · Aug 3, 2003

Leo,

Sure you didn't mean countif -
summing up "pp" (as shown) will always result in a sum of zero.

Regards,
Tom Ogilvy
MVP Excel

Leo Heuser · Aug 3, 2003

Of course I meant COUNTIF()
Sudden short-circuit :-(

Thanks, Tom!

--
Best Regards
Leo Heuser
MVP Excel

Followup to newsgroup only please.

Susan · Aug 3, 2003

thank you tom for your response,this was the first time I
have used this support. I appreciate your help very much.
Susan

Susan · Aug 3, 2003

Thanks Leo for your help.
Susan

-----Original Message-----
Susan

Check out the SUMIF() -function.
E.g.:
=SUMIF(A2:L2, "pp")

--
Best Regards
Leo Heuser
MVP Excel

Followup to newsgroup only please.

.