sum cells based on multiple criteria
Hi Jessie
assuming you're not using VBA code to do this then one formula would be
=SUMPRODUCT(--(A6:A66="date"),--(E6:D66="dept"),G6:G66)
note, if you're using actual dates and not the cell reference containing the
date you want to sum on, you need to put the date into another function e.g.
=SUMPRODUCT(--(A6:A66=DateValue("01/01/05")),--(E6:D66="dept"),G6:G66)
Cheers
JulieD
"jessie" wrote in message
...
hello,
i am trying to sum cells G6:G66 only if (A6:A66="date" and E6:E66="dept")
does anyone have an idea of how to do this.
thank you,
jessie
|