countif with AND comparing 3 columns
 

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

countif with AND comparing 3 columns
 

Johndb wrote:
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

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.

countif with AND comparing 3 columns
 

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

"smartin" wrote:

Johndb wrote:
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

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.