LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 16
Default is there an easier/faster way to do what I'm doing in 3 steps

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:
" A mistake is not a mistake, but a mistake well made, if we learn
from it".
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
making steps damorrison Excel Discussion (Misc queries) 1 April 19th 06 01:04 PM
steps to eM URL? [email protected] Excel Discussion (Misc queries) 1 March 5th 06 08:02 PM
steps to display .wmf ? [email protected] Excel Discussion (Misc queries) 1 March 2nd 06 10:27 PM
Can faster CPU+larger/faster RAM significantly speed up recalulati jmk_li Excel Discussion (Misc queries) 2 September 28th 05 10:24 AM
Baby steps..... cpegram Excel Discussion (Misc queries) 5 June 4th 05 09:32 PM


All times are GMT +1. The time now is 09:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"