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

K

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Payment calculation 1
counting multiple criteria using SUMPRODUCT and getting #VALUE err 1
Creating a variable and pickout data 1
Create if partial match then copy and paste data from one cell to another 1
Sumif Multiple Columns 2
Insert Formula and Copy to other cells 1
How to do an IF statement that copy data based on a partial match 0
adding text to a sumproduct formula 2

Top