SUM Function with Multiple Conditions II


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!!!
 
Ad

Advertisements

P

Peo Sjoblom

Why don't you stay in the same thread, that way it is possible
to see where this formula came from?
 
Ad

Advertisements

G

Glendy

I posted the new criteria in the old thread. Hope this
helps! Thanks so much!

Glendy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top