B
Brandy
Still looking for help... see post today at 9:23. Thanks
thanks thanks
thanks thanks
P
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)
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)
F
Frank Kabel
Hi
simply add both formulas. e.g.:
=COUNTIF(B:B,"d")+COUNTIF(G:G,"m")
simply add both formulas. e.g.:
=COUNTIF(B:B,"d")+COUNTIF(G:G,"m")
B
Brandy
Thank you so much Frank... that was PERFECT 