Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 6th 05, 09:43 PM
ANDY CALLAGHAN
 
Posts: n/a
Default FORMULA REQD FOR ADD ING DATES AND VALUES AND PART NUMBERS

I am trying to do a formula that will add up all the values for each part
sold in a specify period.

worksheet is column based , 10000 lines of various different part numbers in
column A, 10000 different sales values column D and 365 different dates
invoiced column H.

I need to break this down to how much each part generated in each quarter eg
today()-90, today())-180 , today()-270, today()-365

please help as I really am stuck on this , im thinking of the lines of a
sumproduct approach, but just cant quite sort it out in my head, many thanks

I would prefer email to my home adress as I can
access this at any time through the day

andy


  #2   Report Post  
Old March 6th 05, 10:35 PM
Ragdyer
 
Posts: n/a
Default

Will this work for you?

Say you have a master list of your part numbers in Column J.
Start date of calculation in L1
End date of calculation in L2

Enter this in K1:

=SUMPRODUCT(($A$1:$A$10000=J1)*($H$1:$H$10000=$L$ 1)*($H$1:$H$10000<=$L$2)*$
D$1:$D$10000)

And copy down as far as the length of the master parts number list.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"ANDY CALLAGHAN" <ANDY wrote in message
...
I am trying to do a formula that will add up all the values for each part
sold in a specify period.

worksheet is column based , 10000 lines of various different part numbers

in
column A, 10000 different sales values column D and 365 different dates
invoiced column H.

I need to break this down to how much each part generated in each quarter

eg
today()-90, today())-180 , today()-270, today()-365

please help as I really am stuck on this , im thinking of the lines of a
sumproduct approach, but just cant quite sort it out in my head, many

thanks

I would prefer email to my home adress
as I can
access this at any time through the day

andy




Reply
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



All times are GMT +1. The time now is 08:20 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017