Sumproduct question
Without knowing specifically what you have in column A, B or C, here is my
suggestion
=SUMPRODUCT(--(A1:A100="August"),--(B1:B100=1),--(C1:C100=2007),
--(D1:D100="Bob"))
HTH,
Barb Reinhardt
"wx4usa" wrote:
I just want to count the number of entries, not a sum of totals.
column A is Month, B is Day, C is year, D is Name
Can I use sumproduct to just return the number of entries for "Bob" on
August, 1, 2007? Bob may have anywhere from 1-20 lines of data in
this scenario, I just want to know how many occurrences, not an actual
sum of some numbers.
|