Computing values in Excel - TechRepublic
General discussion
May 30, 2011 at 07:00 AM
sivey

Computing values in Excel

by sivey . Updated 15 years, 1 month ago

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 discussion is locked

All Comments