Time to meet SUMPRODUCT

In place of
{=SUM((MONTH(Data!$E$3:$E$6000)=$A3)*(YEAR(Data!$E $3:$E$6000)=$A$2))} Use
=SUMPRODUCT
(--(MONTH(Data!$E$3:$E$6000)=$A3), --(YEAR(Data!$E$3:$E$6000)=$A$2)) This
is NOT an array formula so just complete it with ENTER

For non-blanks
=SUMPRODUCT
(--(MONTH(Data!$E$3:$E$6000)=$A3), --(YEAR(Data!$E$3:$E$6000)=$A$2), --(Data!$F$3:$F$6000""))

For more info see
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
explains the "--":
http://mcgimpsey.com/excel/formulae/doubleneg.html


best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Paul" wrote in message
...
I am building a call log sheet for a friend. He needs to log each phone
call he makes each month, and track numbers of call-back requests.

There are 2 columns in question. Column E is the date that the phone call
was originally made. Every used row will have a date in col E. Column F
contains a note related to the call-back request. If there is no further
action required, the cell in col F will be blank.

My goal is to have a function (probably array function) to count the
number of non-blank cells in col F for each month, as noted in col E of
the phone call date. The analysis will appear on a separate sheet.

Example source data:
E F
2/1/2006 call back 5/4
2/1/2006
2/16/2006 send fax
2/27/2006
3/1/2006
3/7/2006 call back 4/1
3/8/2006 email pricelist
3/9/2006
3/14/2006
3/18/2006 call back 5/12

Example Results:

Feb. 2006: 2
Mar. 2006: 3

I am currently using array function
{=SUM((MONTH(Data!$E$3:$E$6000)=$A3)*(YEAR(Data!$E $3:$E$6000)=$A$2))} to
simply count the number of calls made, but am stumped as far as counting
non-blank cells adjacent to this column.

Thank you for your assistance.