SOLVED

# COUNTIFS

Copper Contributor

# 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?

2 Replies
best response confirmed by aralston3 (Copper Contributor)
Solution

# Re: COUNTIFS

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.

# Re: COUNTIFS

1 best response

Accepted Solutions
best response confirmed by aralston3 (Copper Contributor)
Solution

# Re: COUNTIFS

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.