Lessthan or =,Greater than and Sum
Solved/Closed
Gouws
Posts
45
Registration date
Sunday February 7, 2010
Status
Member
Last seen
April 15, 2012
-
Aug 13, 2010 at 06:21 AM
jack4rall Posts 6428 Registration date Sunday June 6, 2010 Status Moderator Last seen July 16, 2020 - Aug 16, 2010 at 07:04 AM
jack4rall Posts 6428 Registration date Sunday June 6, 2010 Status Moderator Last seen July 16, 2020 - Aug 16, 2010 at 07:04 AM
Related:
- Lessthan or =,Greater than and Sum
- Check sum error - Guide
- How to sum names in excel - Guide
- Sum multiple values from data validation list - Excel Forum
- Sum in french excel - Guide
1 reply
Gouws
Posts
45
Registration date
Sunday February 7, 2010
Status
Member
Last seen
April 15, 2012
Aug 16, 2010 at 04:39 AM
Aug 16, 2010 at 04:39 AM
Found the formula:
=SUMPRODUCT((A1<=B1)*(A1>=C1)*(D1>E1)+(F1-G1))
=SUMPRODUCT((A1<=B1)*(A1>=C1)*(D1>E1)+(F1-G1))
Aug 16, 2010 at 07:04 AM
Thanks for coming back to post the answer.