| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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) |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to extract data from a column | Excel Discussion (Misc queries) | |||
| extract data from multiple workbooks | Excel Discussion (Misc queries) | |||
| Extract data in put in a new column | Excel Worksheet Functions | |||
| extract data from multiple worksheets | Excel Worksheet Functions | |||
| How to extract data from multiple worksheets.. | Excel Discussion (Misc queries) | |||
Linear Mode
