Hi
try something like
=SUMIF(C1:C10,"="&DATE(2004,12,1),B1:B10)-SUMIF(C1:C10,""&DATE(2004,12,7),B1:B10)
--
Regards
Frank Kabel
Frankfurt, Germany
Armando wrote:
Hi, i just built a spreadsheet that contains on col A store numbers,
col B amounts and col C dates (for 10 days), i also built a sort of a
"table reference" that the lookup formula should refer to and sum the
amounts for only 7 days instead of the full 10 days according to the
stores that are in the "table reference". is this even possible? any
help is really appreciated. Armando
|