countifs

[Dalia]

Often I get this error. why my countifs function not happening. please explain where am going wrong. Everytime i get this error am not able to find out my mistake.
Attached is the file

 

[Ronak Parekh]

Data range for price quantity was incorrect. Please find the updated file in attachment...

=COUNTIFS(Sheet1!A2:A8,"tomatoes",Sheet1!B2:B8,">20")

 

[tomas]

Hi

problem is all criteria's ranges must be of same length.

In your case it's not
Sheet1!A2:A8;Sheet1!B2:B7.

 

[bobhc]

Change your formula to include ALL of the B column data.

=COUNTIFS(Sheet1!A2:A8,"tomatoes",Sheet1!B2:B8,">20")