Summing up Invoice Total

[rizmomin]

Please see attached sheet for referance.

I need the Dollar total of invoice from Jul10 Sheet in Product Summary sheet in Column B to the corresponding date.

Column A B

eg : 7/5/2010 .... $2462.54 This is the total of Cell (H2:H52)

7/12/2010..........$ 2711.05 This is the total of cell (H53:H106)

and so on...

please help me accomplish this task either with VB Code or Formula

Thanks

Riz Momin

[JieJenn]

Here you go. I use array formula column L and M

[JieJenn]

sorry, i forgot to lock the table from H2 to H220. Just add the $ and enter control + shift + enter.

[stanleydgromjr]

rizmomin,


I am glad that you liked my Index Match If formula.


The formula in sheet Product Summary, cell B4 (copied down):

=SUMIF(Jul10!J:J,A4,Jul10!H:H)

[rizmomin]

Thank U so much ...this works great for me....

Riz