sum cells based on multiple criteria

[Guest]

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

 

[JulieD]

Hi Jessie

assuming you're not using VBA code to do this then one formula would be
=SUMPRODUCT(--(A6:A66="date"),--(E666="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")),--(E666="dept"),G6:G66)

Cheers
JulieD

 

[Frank Kabel]

Hi
=SUMPRODUCT(--(A6:A66="date"),--(E6:E66="dept"),G6:G66)

Also see:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html