Counting based on multiple criteria
 

I have two columns that have drop down boxes with either a Yes or a No
as the only inputs. I need to be able enter a formula that counts up
the total "No" inputs in one column but count it up only if the other
column says yes. Any suggestions.


--
cubsfan
------------------------------------------------------------------------
cubsfan's Profile: http://www.excelforum.com/member.php...o&userid=33272
View this thread: http://www.excelforum.com/showthread...hreadid=534736

Counting based on multiple criteria
 

If you can Concatenate the two into the next column, you could then
count the NoYes entries in that column.


--
stvgarner
------------------------------------------------------------------------
stvgarner's Profile: http://www.excelforum.com/member.php...o&userid=20599
View this thread: http://www.excelforum.com/showthread...hreadid=534736