Sumif
I would like to use multiple criteria for adding up data in my worksheet.
I've tried Dsum and Sumif but can't get either to address multiple criteria. As I understand SumIf, there is one arguement for criteria. How can I add a criteria for my example below? Perhaps I should be asking if this is the appropriate command? ColA ColB ColC ColD ColE Name Age Loc Date Amt 1 Smith 30 WA 2001 150 2 Jones 40 CA 2001 350 3 Selles 32 OH 2004 240 4 Kayt 45 WA 2002 200 5 Mink 24 WA 2000 250 Sumif(B1..B5, 25 AND C1..C5, = "WA", E1..E5) |
Hi
use SUMPRODUCT. e.g. =SUMPRODUCT(--(B1:B2525),--(C1:C5="WA"),E1:E5) Also see: http://www.xldynamic.com/source/xld.SUMPRODUCT.html -- Regards Frank Kabel Frankfurt, Germany briank wrote: I would like to use multiple criteria for adding up data in my worksheet. I've tried Dsum and Sumif but can't get either to address multiple criteria. As I understand SumIf, there is one arguement for criteria. How can I add a criteria for my example below? Perhaps I should be asking if this is the appropriate command? ColA ColB ColC ColD ColE Name Age Loc Date Amt 1 Smith 30 WA 2001 150 2 Jones 40 CA 2001 350 3 Selles 32 OH 2004 240 4 Kayt 45 WA 2002 200 5 Mink 24 WA 2000 250 Sumif(B1..B5, 25 AND C1..C5, = "WA", E1..E5) |
Try the following...
=SUMPRODUCT(--(B2:B625),--(C2:C6="WA"),E2:E6) Hope this helps! In article , briank wrote: I would like to use multiple criteria for adding up data in my worksheet. I've tried Dsum and Sumif but can't get either to address multiple criteria. As I understand SumIf, there is one arguement for criteria. How can I add a criteria for my example below? Perhaps I should be asking if this is the appropriate command? ColA ColB ColC ColD ColE Name Age Loc Date Amt 1 Smith 30 WA 2001 150 2 Jones 40 CA 2001 350 3 Selles 32 OH 2004 240 4 Kayt 45 WA 2002 200 5 Mink 24 WA 2000 250 Sumif(B1..B5, 25 AND C1..C5, = "WA", E1..E5) |
All times are GMT +1. The time now is 10:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com