I am trying to sum data from a database using excel. The following gets me results for one criteria but I need help with this formula for multiple criteria. In other words "sum values where condition is both criteria 1 and 2 at the same time"...the formula is below.

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

Thanks,
Jems

Recommended Answers

If you have a database, why not use SQL instead of putting it in Excel?

Jump to Post

All 2 Replies

Member Avatar

If you have a database, why not use SQL instead of putting it in Excel?

You could always use the IIF construct for that.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.