General discussion

Locked

Computing values in Excel

By sivey ·
Below is a sample formula and I would like to sum data for date range and two different criteria. I can do it for one criteria but need help with second criteria the formula is below:

Start Date End Date2 Criteria1 Values
=SUM((BB2:BB366>=B3)*(BB2:BB366<=B5)*(BF2:BF366=B10)*(BG2:BG366))

This conversation is currently closed to new comments.

0 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Back to Software Forum
0 total posts (Page 1 of 1)  

Related Discussions

Related Forums