Thread: sum cells based on multiple criteria
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
  
Posts: 3,885
Default sum cells based on multiple criteria
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

Reply With QuoteReply With Quote