formula help please

[Susan]

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]

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]

=countif(1:1,"pp")

=countif(1:1,"vd")

=countif(1:1,"sd")


Regards,
Tom Ogilvy

 

[Tom Ogilvy]

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]

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

Thanks, Tom!

--
Best Regards
Leo Heuser
MVP Excel

Followup to newsgroup only please.

 

[Susan]

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

 

[Susan]

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.




.