Sum Categories

[Ed Davis]

I have a workbook where 1 sheet has category numbers In Column A 1 - 10. and
column B has the description of the categories.
Another worksheet has a column of all items for sale and using vlookup for
the category Descriptions.
And still another has the sales for any given day. However because the list
is about 200 items I had to put 2 separate sections on this sheet.
Section 1 has b1 - h72 and section 2 has I 1 through O72 These hold the
sales for the day by Item.

What I am trying to do id get the total for each category The category # is
in columns B + I and the sales are in H + O.
I tried using a Pivot table but it does not do the trick for me because of
the two sections.

The category numbers may not be in numerical order but I would like to the
total for each Category.
I thought I saw something here about this type of calculation but have been
unable to find it.

 

[Max]

What I am trying to do is get the total for each category The category #

is in columns B + I and the sales are in H + O

Assume the above sheet (sales figs) is named: x

Then in your sheet with the "category numbers In Column A 1 - 10"
you could place this in C1:
=SUM(SUMIF(x!B:B,A1,x!C:C),SUMIF(x!I:I,A1,x!O:O))
and copy down to C10 to derive it
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---

 

[Max]

Correction, it should read:
=SUM(SUMIF(x!B:B,A1,x!H:H),SUMIF(x!I:I,A1,x!O:O))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---