Find the sum of data that has multiple conditions in Excel
Solved/Closed
acohen12
Posts
5
Registration date
Thursday June 6, 2013
Status
Member
Last seen
June 13, 2013
-
Jun 6, 2013 at 11:13 PM
Kevin@Radstock Posts 42 Registration date Thursday January 31, 2013 Status Member Last seen April 26, 2014 - Jun 7, 2013 at 07:26 AM
Kevin@Radstock Posts 42 Registration date Thursday January 31, 2013 Status Member Last seen April 26, 2014 - Jun 7, 2013 at 07:26 AM
Related:
- Find the sum of data that has multiple conditions in Excel
- Transfer data from one excel worksheet to another automatically - Guide
- Excel date format dd.mm.yyyy - Guide
- Allow multiple downloads chrome - Guide
- Excel data validation list from table multiple columns - Guide
- Screenshot in excel - Guide
1 reply
Kevin@Radstock
Posts
42
Registration date
Thursday January 31, 2013
Status
Member
Last seen
April 26, 2014
9
Jun 7, 2013 at 07:26 AM
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!
