Related:
- Find the sum of data that has multiple conditions in Excel
- Excel data validation list multiple columns - How-To - Excel
- How to insert multiple rows in excel between data using macro - How-To - Excel
- How to sum same cell in multiple sheets in excel - How-To - Excel
- Adding new data sets to multiple worksheets ✓ - Forum - Excel
- Summing up data from groups & pasting it another column ✓ - Forum - Excel
1 reply
Kevin@Radstock
- Posts
- 42
- Registration date
- Thursday January 31, 2013
- Status
- Member
- Last seen
- April 26, 2014
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!
