I want to count the total number of rainy days on sunday

Last Edited By Krjb Donovan
Last Updated: Mar 05, 2014 09:41 PM GMT

Question

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.

Answer

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

©2020 eLuminary LLC. All rights reserved.