counting values from 3 columns help!!

Hi i am an excel beginner need help with this formula.I need to calculate values from 2 rows if one of the rows meet the condition.

This is what i tryed ,but it does not work

=COUNTIF(A2:A1001,”=Male” AND(B2:B1001,”>80″) AND(C2:C1001,”>120″))

By: Werner

Leave a Reply

Your email address will not be published. Required fields are marked *