Sum up formula

[adamsm]

Hi anyone,

How could I write a sum up formula that would apply for the following purpose. Suppose;

The user types January in cell AA9 and 2011 in cell AH9; I want the formula to copy all the fruits that has been sold to all the "OUT" customers (from column L of the sheet "Mysheet") to get copied to the cells of the steet "stat" starting from "D11" to AI11 and fruits sold to all the IN customers to get copied to the cells starting from "D12" to "AI12" of the same sheet.

And when the user selects another month like February or any other month, all the data related to February to get copied to the above mentioned cells.

I hope I've made my question clear.

Any help would be kindly appreciated.

 

[Steve=True]

This can be done, but it is hard without seeing sample data.

Try to upload a file and paste the link a sample spreadsheet using this site:

www.4shared.com

 

[adamsm]

Thanks for the reply. Here's the link
http://www.4shared.com/file/6qzuQBoX/Formula.html

Any help on this would be kindly appreciated.

 

[Steve=True]

Cell D11 on Stat Sheet should =

=SUMPRODUCT(--(MONTH(DATEVALUE(TEXT(MySheet!$AB$16&" "&1&", "&MySheet!$AH$16,"mm/dd/yy")))=MONTH(MySheet!$G$17:$G$39)*((MySheet!$F$17:$F$39)=VALUE(Stat!D$10))*((MySheet!$L$17:$L$39)=Stat!$C11)))

Not sure if you were looking to match it to the day or the 1 2 3 4...23 in column (f17:f39.

Copy this formula down to d12 and across.

Also, you have 2x 21's on your STAT spreadsheet. So you should remove one as this will double count entries in 21 and give you bad totals.

 

[adamsm]

Thanks for the help. But there seems to be a concern with the formula.

What I'm trying to get is suppose the user writes January in cell AA9 and year in cell AH9; I want all the OUT customers for day 1 to get copied to cell D11 and all the IN customers for day 1 of January to get copied to cell D12.

I want the same to happen to January 1,2,3,4 and so on until 31st.

Was the provided formula meant to do so? I tried it but am unable to succeed.

Any further suggestions on this would be kindly appreciated.

Thanks in advance.