| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
sum with 2 criteria
With the below eqn do the dates have to be a cell reference or is it possible
to use a specific date? One way =SUMPRODUCT(--(A2:A50="Department"),--(B2:B50=D2),--(B2:B50<=E2),C2:C50) where D2 hold the start date, E2 the end date and C2:C50 the amount/values to sum -- Regards, Peo Sjoblom (No private emails please) "Dave" wrote in message ... I have an excell sheet that gets updated daily with submissions from different departments, what i want to do is to use a formula to submission by the department and between two dates |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find largest alphanumeric value matching alpha criteria in databas | Excel Worksheet Functions | |||
| sorting more than 3 keys | Excel Discussion (Misc queries) | |||
| Countif using format criteria....not number criteria? | Excel Worksheet Functions | |||
| Can I get the mode, min, and max with multiple criteria? | Excel Discussion (Misc queries) | |||
| SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions | |||
Threaded Mode
