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 function works with each one alone, but not together. Can anyone tell me what is going wrong?
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.
2 Replies
- Glad to help you,,, please keep asking ☺
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.