COUNTIF for multiple criteria?
Posted by Mike Winters on December 01, 2001 9:43 AM
I have a formula:
which works fine, but I need it to also count all occurences of "1LT" and "CPT" in the same range, and return the total of all of them. I have tried using several variations of
=COUNTIF(G4:G83,"2LT" OR("1LT","CPT")), as well as some SUM and SUMIF/ SUM(IF formulas, but none work the way I want it to, they just give me erros. Any ideas on this one?
United States Army