| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Sum using multiple criteria
What equation would I use to be able to sum a column based on multiple
criteria from another column? i.e..... sum if AG or AG AG 50.00 Total AD 25.00 75.00 DE 10.00 SG 45.00 |
|
#2
|
|||
|
|||
|
One way:
=SUMPRODUCT((A1:A4="AG")+(A1:A4="AD"),B1:B4) In article , Barbara 1 <Barbara wrote: What equation would I use to be able to sum a column based on multiple criteria from another column? i.e..... sum if AG or AG AG 50.00 Total AD 25.00 75.00 DE 10.00 SG 45.00 |
|
#3
|
|||
|
|||
|
See answer to your previous post, try to stay in the same thread
Regards, Peo Sjoblom "Barbara 1" wrote: What equation would I use to be able to sum a column based on multiple criteria from another column? i.e..... sum if AG or AG AG 50.00 Total AD 25.00 75.00 DE 10.00 SG 45.00 |
|
#4
|
|||
|
|||
|
Hi
try =SUMPRODUCT(--(A1:A100={"AG","AD"}),B1:B100) Also see: http://www.xldynamic.com/source/xld.SUMPRODUCT.html -- Regards Frank Kabel Frankfurt, Germany "Barbara 1" <Barbara schrieb im Newsbeitrag ... What equation would I use to be able to sum a column based on multiple criteria from another column? i.e..... sum if AG or AG AG 50.00 Total AD 25.00 75.00 DE 10.00 SG 45.00 |
|
#5
|
|||
|
|||
|
Hi
should be: =SUMPRODUCT((A1:A100={"AG","AD"})*(B1:B100)) -- Regards Frank Kabel Frankfurt, Germany "Frank Kabel" schrieb im Newsbeitrag ... Hi try =SUMPRODUCT(--(A1:A100={"AG","AD"}),B1:B100) Also see: http://www.xldynamic.com/source/xld.SUMPRODUCT.html -- Regards Frank Kabel Frankfurt, Germany "Barbara 1" <Barbara schrieb im Newsbeitrag ... What equation would I use to be able to sum a column based on multiple criteria from another column? i.e..... sum if AG or AG AG 50.00 Total AD 25.00 75.00 DE 10.00 SG 45.00 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I ask for multiple criteria when creating a "sumif" formul. | Excel Worksheet Functions | |||
| SUMIF multiple criteria in 1 range | Excel Worksheet Functions | |||
| Counting "rows", i.e. simultaneous criteria for multiple cells | Excel Worksheet Functions | |||
| calculate percent from multiple criteria | Excel Worksheet Functions | |||
| Count rows based on multiple criteria | Excel Worksheet Functions | |||
Linear Mode
