Thisworked perfectly too, thank you
"p45cal" wrote:
something along the lines of
=SUMPRODUCT((MONTH($A$2:$A$7)=8)*($B$2:$B$7<""))
where the 8 represents August.
See attached for a working example with small modification.
Note that if there is more than 1 year in the first column then the
count for each month will include that month from all the years in one
value.
+-------------------------------------------------------------------+
|Filename: Conditional count.xls |
|Download: http://www.thecodecage.com/forumz/attachment.php?attachmentid=222|
+-------------------------------------------------------------------+
--
p45cal
*p45cal*
------------------------------------------------------------------------
p45cal's Profile: http://www.thecodecage.com/forumz/member.php?userid=558
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=126146