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


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


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)


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.


©2024 eLuminary LLC. All rights reserved.