What formula should I use to extract multiple data from one column

[KellyC]

I have a spreadsheet that requires pulling three different criteria from the
same column and summing the result; however, I have four possibilities. I
have created the following formula, which works, but it seems long and
cumbersome. Is there something else like SUMPRODUCT? Thank you!

=SUMIF(D815,"A",E8:E16)+SUMIF(D815,"D",E8:E15)+SUMIF(D815,"C",E8:E16)

 

[Peo Sjoblom]

One way


=SUM(SUMIF(D815,{"A","D","C"},E8:E15))




--


Regards,


Peo Sjoblom

 

[KellyC]

Thank you. That worked perfectly!!

One way


=SUM(SUMIF(D815,{"A","D","C"},E8:E15))




--


Regards,


Peo Sjoblom