Sum Values Based on Month and Product

[akbar]

Hello,

I had Table with 3 columns with heading Date,Products and price,what i am trying to do is
to create a summary based on this table,it should add the values of the month separately based
on the date of my table..

Thanks,
Ak

[dilipandey]

Hi Akbar,

I would suggest you to use a pivot table in this case. Upload a sample file if you face any issue. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

[akbar]

Hi Dileep i dont want to use a pivot table just looking for a formula or a macro which
can help..please find the attached file..

Thanks,
Ak

[dilipandey]

Hi Akbar,

See the attached file where I have provided few formulas to achieve the results

Further to this, you can use vlookup to obtain budgets for apple, oranges if you wish

Trial Copy 1.xlsx

Regards,
DILIPandey

<click on below 'star' if this helps>

[akbar]

Hi Dilipandey,,

But when i copy down the formula and when click enter it gives me #VALUE..

Thanks,
Ak

[Fotis1991]

Hi AK.

1) As i see that Dilip is offline, his formula in H8, is Array. So you need to confirm with Control+Shift+Enter. Not just Enter.

2) Do you also want to extract the months Automatically, or this is OK for you?

[akbar]

I need to extract the months automatically as well..

Thanks,
Ak

[Fotis1991]

Ok. Give me some time.

[akbar]

okkk fine..

[Fotis1991]

So my suggestion is here.

In every column of your table the results are with formulae, except in column G that there is a validation list for choosing the fruits that you want to see.

Formula in column F is an Array Formula, so you need to confirm with Control+Shift+Enter. The other formulae are normal. Just Enter.

I also made a small Table with fruits budget.

Let me know if there is something that you don't understand.

[akbar]

Fotis that seems to be fine..except the sum for the months together..can you have a look on that please..

Thanks,
Ak

[Fotis1991]

What do you mean, Ak?

Where is this?

[akbar]

Within the valiadtion list just i need to add "Total Expenses" and in the exepenses column total sum for the
corespondent month too..Hope you understand..

F8: June
G8:Total Expenses
H8sum of expenses for the month of june


Thanks,
Ak

[Fotis1991]

Within the valiadtion list just i need to add "Total Expenses" and in the exepenses column total sum for the
corespondent month too..Hope you understand..

F8: June
G8:Total Expenses
H8sum of expenses for the month of june


Thanks,
Ak

Unfortumately NO. I am comfused..

In G8 what is the expcted result? 75.9 ?

In H8 ? 4 ?

If not, pls upload my sample and show to me where you want and what is this.

[akbar]

Fotis just see the attachment and i had comments on H8..

Thanks,
Ak

[Fotis1991]

Look at the example, Ak.

Please Login or Register  to view this content.

[akbar]

That is fabulous work..it helps fotis...

Thanks,
Ak