=SUMIFS(Data!E:E, Data!I:I,A4, Data!J:J,B4, Data!D:D,">="&VALUE($B
$1), Data!D:D,"<="&VALUE($B$2))
The formula is simple and works in 2007 version of excel only. First
parameter [Data!E:E] specifies the range to sum and rest are the
criterion you need to test. As for coumn D Value formula has
Hi Bonnie,
This is definitely a job for the SUMPRODUCT function, which is a wizz at doing
just what you are asking about.
If you post a sample of your data, there would be many is this group that could
help you with it.
Regards - Dave.
> Date: Thu, 5 Nov 2009 11:36:35 -0800
> Subject: $$Exc
