On Aug 9, 6:55 pm, Dallman Ross <dman@localhost. wrote:
In . com, wx4usa
spake thusly:

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.

You're not giving sufficient information. Is the month a word
("April"), and abbreviation ("Apr" or "Apr."), or a number?

Assuming a word, well, this works, but it's also an array
formula.

=IF(A2:A29="Apr",IF(B2:B29=2,IF(C2:C29=1999,COUNTI F(D:D,"Bob"))))

You could put the dates together with something like this:

=DATE($C15,LOOKUP($A15,{"Jan","Feb","Mar","Apr","M ay"},{1,2,3,4,5}),$B15)

(You'd want to go through December; I just shortened it here
to make it easier.)

There may be other ways.

=dman=

Month is a word.