How to Calculate Group Total Automatically

[kprabhupaul]

Hello All,

I have table of Data containing Quantity of each Item.

That table contains different items by different groups.

Now in a separate space I want output or calculate the total of the each Item Group.

In the sample workbook I entered the totals manually..,

Please give the formula or VBA code to get this automatically ..

Thanks in advance ..

[AliGW]

You need to define somewhere on your sheet what classes as a vegetable, what a fruit, and what is neither, then you can do the calculation.

[JohnTopley]

I add "Category" (Fruits,Vegetables,Non Veg) in column B as per Ali's post;

=SUMIF(Table1[Category],F3,Table1[QTY])

[kprabhupaul]

Thanks for the reply
I will check it
And reply soon ..

[kprabhupaul]

It's working ..
I tried below one too

=sumifs(table1[qty], table1[category], F3)

Thank you so much who helped me..

[JohnTopley]

Thank you for the feedback.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.