P.S. I forgot to add: when compared to manual calculations, the formula is
wrong.

"Mike H" wrote:

Hi,

I can't see anything wrong with the formula so if your getting unexpected
results then maybe the dates are suspect, are they really dates or text that
looks like a date.

Mike

"WildWill" wrote:

I have the following formula:
=SUMPRODUCT((Input!$C$3:$C$48943<"")*(Input!$A$3: $A$48943=DATE(2009,3,30)*(Input!$A$3:$A$48943<=DA TE(2009,4,3))))
I am using this formula in a rather large spreadsheet, A3:J48943, which is a
database logging daily activities of a Marketing Team. Column A contains date
values of the specific activity and Column C contains text values indicating
the activity type, i.e. Cold Calling, Client Visit, etc, etc.

I am trying to achieve the following: Counting the total number of
activities per week. Is my formula above correct? Somehow I doubt it because
when I run a COUNTA on Column C, I get a different value to the totals
reported per week using the above formula. Please help.