Adding two occurrences

[Brandy]

Still looking for help... see post today at 9:23. Thanks
thanks thanks

 

[Peo Sjoblom]

Post in the same thread if you want to have help, don't ask people to find
your earlier posts

=SUMPRODUCT(--(Range1=crieria1),--(Range2=criteria2))

will count the occurrences where criteria1 AND criteria2 are TRUE
replace the ranges with your real ranges but don't use the whole column
(A:A, use A1:A500
or something)

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[Frank Kabel]

Hi
simply add both formulas. e.g.:
=COUNTIF(B:B,"d")+COUNTIF(G:G,"m")

 

[Brandy]

Thank you so much Frank... that was PERFECT

-----Original Message-----
Hi
simply add both formulas. e.g.:
=COUNTIF(B:B,"d")+COUNTIF(G:G,"m")



--
Regards
Frank Kabel
Frankfurt, Germany


.