COUNTIFS

[aralston3]

I keep getting a #VALUE error with my countifs function, but I can't figure out why. 

=COUNTIFS(G1:G12,">=45",H1:H6,">=55")

It's a pretty simple function only containing numbers in the cells. The function works with each one alone, but not together. Can anyone tell me what is going wrong?

[#2 · Accepted solution]

@aralston3 

You need to correct the cell references in the formula, and it should like,,,

=COUNTIFS(G1:G12,">=45",H1:H12,">=55")

• Because the COUNTIFS needs each of the criteria ranges to have the same size.
• Your first criteria range has 12 ROWS, but another has only 6, so that you are getting an error. 

N.B.

• Even after the suggested correction you may get either ZERO to unexpected result, juts because non of the criterion may not meeting the data in used data range.
• I this situation better share some sample data wit us.

[#3]

Glad to help you,,, please keep asking ☺