or you could use like this

=SUM(SUMIF(D6:D23,{"Sales","Production"},E6:E23))

"Teethless mama" wrote:

Try it like this:

=SUM(SUMIFS(E6:E23,D6:D23,{"Sales","Production"}))


"tgavin" wrote:

I am an excel trainer and I am trying to prep the new functions and I can't
get the ifs to work. If I use the functions for 1 criteria, it works, when I
add the 2nd, I get 0 for sumifs and countifs and #div/0! for averageifs.

=SUMIFS(E6:E23,D6:D23,"Sales") returns 166,000

=SUMIFS(E6:E23,D6:D23,"Sales",D6:D23,"Production") returns 0

I am following the tool tips, what am I doing wrong?

Terri