Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Is there an easy way to combine the following 2 equations:
Currently I"m getting my result in 3 steps, I'd like to do it in 1 cell (formula), step 1: =SUMPRODUCT(--('Filled Reqs-Aug'!$R$2:$R$389=DATE(2007,8,1)),--('Filled Reqs-Aug'!$R$2:$R$389<=DATE(2007,8,31)),--('Filled Reqs-Aug'!$B$2:$B$389="finance"),--('Filled Reqs-Aug'!$I$2:$I$389="NC")) cell A2 4 step 2: =SUMPRODUCT(--('Filled Reqs-Sep'!$S$2:$S$389=DATE(2007,9,1)),--('Filled Reqs-Sep'!$S$2:$S$389<=DATE(2007,9,30)),--('Filled Reqs-Sep'!$B$2:$B$389="finance"),--('Filled Reqs-Sep'!$I$2:$I$389="NC")) cell C2 6 step 3: =sum(A2:C2) cell D2 10 Result cell D2 must be 10 Thanks in advance Ralph Quote:
|
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
making steps | Excel Discussion (Misc queries) | |||
steps to eM URL? | Excel Discussion (Misc queries) | |||
steps to display .wmf ? | Excel Discussion (Misc queries) | |||
Can faster CPU+larger/faster RAM significantly speed up recalulati | Excel Discussion (Misc queries) | |||
Baby steps..... | Excel Discussion (Misc queries) |