Excel
Thanks Kostis - that looks better!
Nigel
"vezerid" wrote:
In general this is a problem of "SUMIF with Multiple Criteria" as it is
often asked in the newsgroups. The solution is the SUMPRODUCT function:
=SUMPRODUCT((A1:A100=123456)*(B1:B100=10)*(D1:D100 =--"04/04/06")*(C1:C100))
You can replace the constants with cell references. If so, you only
need to specify the cell for the date, i.e. D1:D100=K1, where K1 holds
the date.
HTH
Kostis Vezerides
|