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
- Number to words in excel - Guide
- How to take screenshot in excel - Guide
- Tmobile data check - Guide
- Dd-mm-yyyy format in excel - Guide
1 response
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!
