SUM Function with Multiple Conditions II

  • Thread starter Thread starter Glendy
  • Start date Start date
G

Glendy

I have three columns,item number, quantity ordered, and
date. I have made a function in a cell that sums up the
quantities of all the item numbers that start off with ME.
However, anything starting with ME-008 had their quantity
multiplied by 24. So far, the formula is:

=SUMPRODUCT((LEFT(Sheet1!A2:A5000,2)="ME")-(LEFT(Sheet1!
A2:A5000,6)="ME-008"))*(Sheet1!B2:B5000))+SUMPRODUCT((LEFT
(Sheet1!A2:A5000,6)="ME-008")*(Sheet1!B2:B5000))*24

I need to add the following information. I need the
formula to filter out the selection by a date interval
that the user inputs. Let's say the user inputs the data
criteria in Sheet2. Starting date is in cell A2 and ending
date is in cell A3. Therefore, the interval is expressed
as ('Sheet1'!A2:A5000>='Sheet2'!A2)* ('Sheet1'!
A2:A5000<='Sheet2'!A3).
How do I add in the date criteria with the existing
formula I have now. I really appreciate any help. Thanks
so much!!!
 
Why don't you stay in the same thread, that way it is possible
to see where this formula came from?
 
Back
Top