COUNTIF with multiple IF's
Posted by JAF on January 11, 2000 5:20 AM
This is another of those annoying and probably very simple things, but I just can't get my head round it at the moment.
What I need is a formula (or macro) that will count the number of records that match 2 specific criteria - where the text in column G is equal to JW AND where the value in column H is greater than zero.
I'm currently using a workaround where I have a hidden column with the formula =IF(AND(G2="JW",H2<>""),1,0) -copied down to all rows - and then calculate the total of the hidden column - it's not eaxctly "elegant" but it does work!
Any assistance greatly appreciated.