Software

Ask something
Discussion Locked

Computing values in Excel

0 helpful
0 replies

by sivey

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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))

0 replies

No replies were posted before this discussion closed.

This discussion is closed to new replies.