I want to count the total number of rainy days on Sunday
A B
Sunday Rain Sunday Sunny Monday Rain Sunday Rain Sunday Rain Monday Sunny Monday Rain Monday Sunny
I have looked at Countif and Sum statements and cannot figure it out. Your help would be much appreciated.
Here is what I have looked at so far: http://www.mrexcel.com/articles/sumif-with-two-conditions.php
AND
http://www.mrexcel.com/articles/sumif-with-two-conditions.php Adesi.
Both your links were the same, but we'll let that go - the easiest way is to use sumproduct (unless you are on2007 at which point its SUMIFS)
=sumproduct(--(a1:a20="Sunday"),--(b1:b20="Rain"))
where a1:b20 equate to the range of data you are summing - enter the formula as a normal formula, exactly as I've typed it with the double negatives and you should get the result you want - these double negatives convert the true and false answers to the numeric equivalent of 1 for true and 0 for false, which is how it works.
Advertisement