MrExcel Publishing
Your One Stop for Excel Tips & Solutions

COUNTIF Function in MS Excel


Posted by Ashley on February 21, 2001 12:29 PM

Does anyone know if you can use more than one criteria when using the COUNTIF function?


Posted by xxx on February 21, 2001 12:36 PM

Thanks,
You're close, but no cigar...

I messed with the Pivot Table, but i need the Project Names in consecutive columns (not rows).

What I was hoping to find was a way to get the VLOOKUP function to deliver me not just the 1st occurence of the criteria in an arrauy, but the Nth occurence (or whatever occurence I specified).

I'm still looking for the answer... anyone else?

Posted by Aladin Akyurek on February 21, 2001 12:40 PM

No. But there are alternative methods of computing multiple criteria that must hold at the same time. Perhaps you can tell us what you want to do (with a bit of data if possible).

Aladin

Posted by Mike on February 21, 2001 12:43 PM

Try something like
=COUNTIF(array,AND(criteria1,criteria2))

If you want to use SUMIF, you need to write a macro using {} brackets and some other stuff that can be found by using the Excel Help function, searching on SUMIF and selecting the Examples of Common Formulas and reading all the way down...

Posted by xxx on February 21, 2001 1:01 PM

Please see Mr Excel excellent tip on array formulas..it's exactly what you need

http://www.mrexcel.com/tip031.shtml