sumproduct of 2 columns with date and name
Why do you say it doesn't work?
excel guru i''m not wrote:
This is the formula I am using but it doesn't work.
any suggestions?
I am trying to add the number of times that in one column it says any date
of january and in the other column it says Tom. Not counting any blank rows
in the date column.
=SUMPRODUCT(--(TEXT($J$4:$J$97,"mmm")="jan"),--($J$4:$J$97<"")*($O$4:$O$97="tom"))
--
Dave Peterson
|