Find the sum of data that has multiple conditions in Excel
Solved/Closed
acohen12
Kevin@Radstock
- Posts
- 5
- Registration date
- Thursday June 6, 2013
- Status
- Member
- Last seen
- June 13, 2013
Kevin@Radstock
- Posts
- 42
- Registration date
- Thursday January 31, 2013
- Status
- Member
- Last seen
- April 26, 2014
Related:
- Find the sum of data that has multiple conditions in Excel
- Excel data validation list multiple columns - Guide
- How to copy data to multiple worksheets in Excel - Guide
- How to insert multiple rows in excel between data using macro - Guide
- How to enter same data in multiple sheets in excel - Guide
- Adding new data sets to multiple worksheets ✓ - Forum - Excel
1 reply
Kevin@Radstock
Jun 7, 2013 at 07:26 AM
- Posts
- 42
- Registration date
- Thursday January 31, 2013
- Status
- Member
- Last seen
- April 26, 2014
Jun 7, 2013 at 07:26 AM
Hi acohen12
Here are a couple of ways, the criteria is hard coded in, it would be better to reference cells for your criteria.
For Excel 2007 and later:
=SUMIFS(C2:C100,A2:A100,"Shirt",B2:B100,">=01/01/2013",B2:B100,"<=31/03/2013")
For Excel 2003 and earlier:
=SUMPRODUCT(--(A2:A100="Shirt"),--(B2:B100>="01/01/2013"+0),--(B2:B100<="31/03/2013"+0),C2:C100)
The answer should be $25 not $45!
Here are a couple of ways, the criteria is hard coded in, it would be better to reference cells for your criteria.
For Excel 2007 and later:
=SUMIFS(C2:C100,A2:A100,"Shirt",B2:B100,">=01/01/2013",B2:B100,"<=31/03/2013")
For Excel 2003 and earlier:
=SUMPRODUCT(--(A2:A100="Shirt"),--(B2:B100>="01/01/2013"+0),--(B2:B100<="31/03/2013"+0),C2:C100)
The answer should be $25 not $45!