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

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(D8:D15,"A",E8:E16)+SUMIF(D8:D15,"D",E8:E15) +SUMIF(D8:D15,"C",E8:E16)

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

One way


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




--


Regards,


Peo Sjoblom

"KellyC" wrote in message
...
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(D8:D15,"A",E8:E16)+SUMIF(D8:D15,"D",E8:E15) +SUMIF(D8:D15,"C",E8:E16)

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

Thank you. That worked perfectly!!

"Peo Sjoblom" wrote:

One way


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




--


Regards,


Peo Sjoblom

"KellyC" wrote in message
...
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(D8:D15,"A",E8:E16)+SUMIF(D8:D15,"D",E8:E15) +SUMIF(D8:D15,"C",E8:E16)