Here is what i have i have a table that has 5 columns; Category, Date,
Amount, Description, Location. i have made these columns as References if
that helps too.
What i want is a formula that i can use to sum a full days worth of data.
For instance i would like to sum all data that is on in the category of
Accounts payable on the day of 10/18/2009. I have already tried the
SUMPRODUCT function and it is giving me #NUM. here is my formula what am i
doing wrong.
=SUMPRODUCT((Date=A24)*(Category=$E$3))