• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

countifs

D

Dalia

Member
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
 

Attachments

  • chandoocount.xlsx
    9.6 KB · Views: 0
Data range for price quantity was incorrect. Please find the updated file in attachment...

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

Attachments

  • chandoocount.xlsx
    10.1 KB · Views: 0
Hi

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

In your case it's not
Sheet1!A2:A8;Sheet1!B2:B7.
 
Change your formula to include ALL of the B column data.

=COUNTIFS(Sheet1!A2:A8,"tomatoes",Sheet1!B2:B8,">20")
 
You must log in or register to reply here.
Back
Top