countif with AND comparing 3 columns

  • Thread starter Thread starter Johndb
  • Start date Start date
J

Johndb

Need help.

Ineed to add an AND command to the following formula and can't seem to
figure it out.

=SUM(IF(ISNUMBER(G3:G37),IF(ISNUMBER(H3:H37),IF(H3:H37=G3:G37,1,0))))

It also needs to check if b3:b37 is = to "S"

Any assistance would be geatly appreciated.

Warmest Regards,

John
 
Thanks, workrf perfectly!!!!!!!!!!!!!!!!

smartin said:
Two ways:

=SUMPRODUCT(ISNUMBER(G3:G7)*ISNUMBER(H3:H7)*(G3:G7=H3:H7)*(B3:B7="S"))

Array* formula:
=SUM(IF(ISNUMBER(G3:G7)*ISNUMBER(H3:H7)*(G3:G7=H3:H7)*(B3:B7="S"),1))

*An array formula must be committed by pressing Ctrl+Shift+Enter. Do not
just press Enter or Tab.
Click to expand...
 
Back
Top