ExcelBanter - Countif...and

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Countif...and (https://www.excelbanter.com/excel-discussion-misc-queries/196705-countif.html)

heater

Countif...and

I need a formula to count the No's in column S only if column J is Yes: IF
J29:J80 is "Yes" and S29:S80 is "No" then count, If J29:J80 is "No" and
S29:S80 is "No" DO NOT count the No in column S.

M Kan

Countif...and

=sumproduct(--(J29:J80="yes"),--(S29:S80="no"))
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips

"heater" wrote:

I need a formula to count the No's in column S only if column J is Yes: IF
J29:J80 is "Yes" and S29:S80 is "No" then count, If J29:J80 is "No" and
S29:S80 is "No" DO NOT count the No in column S.

All times are GMT +1. The time now is 04:04 PM.