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

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

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

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

--
Regards
Frank Kabel
Frankfurt, Germany

"jessie" schrieb im Newsbeitrag
...
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