Member Avatar for jems5

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

  • 3 Contributors
  • 2 Replies
  • 68 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by BitBlt
Member Avatar for stbuchok

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

Member Avatar for BitBlt

You could always use the IIF construct for that.

Be a part of the DaniWeb community

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