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
- Sum sum disney - Download - Puzzle
- Excel sum in french - Guide
- Cmos check sum error - Guide
- Sum column if another column equals ✓ - Excel Forum
- Need a macro to sum range of cells - Excel Forum
1 response
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.