Hi Guys,
Tried to explore with sumifs but failed terribly.. does anyone know a formula that can sum up figures in different columns under the same Category.
Have attached a sample xls..
many thanks..
Hi Guys,
Tried to explore with sumifs but failed terribly.. does anyone know a formula that can sum up figures in different columns under the same Category.
Have attached a sample xls..
many thanks..
Re: Summing Up Based On Category
Why is your data set up like that, it's not very well laid out for formulas or PivotTables?
Re: Summing Up Based On Category
Hi
Hopefully I've understood correctly. Please see attached.
Richard
Re: Summing Up Based On Category
Enter the sumif formula below into H3
[f]=SUMIF($B$2:$G$2,$H2,$B3:$G3)[/f]Then copy across to I3 and then copy down.
Re: Sum Based On Category
Roy,
I cant design a better way.. each product has two figures. and figures are daily... and i wish to see all details by day which is the top row..
Dave, Parsnip
Thanks!
Lloyd
Re: Sum Based On Category
Hi Lloyd, have a look at some good advice here :http://www.ozgrid.com/forum/announcement.php?f=8
paragraph beginning with " Number 1 mistake..."
After your data is laid out as explained a PT f.i. will give you the layout you need very easily, and make further analysis very easy
Good Luck !
Don’t have an account yet? Register yourself now and be a part of our community!