Forum Discussion
Solved
COUNTIFS
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 f...
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.
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.