Using SumIf

[rockamania]

Hey people, Im currently stuck on a major excel question and i have spent the last 3 days working it out and still cant work it out.
please help me.
The whole file has been uploaded to megaupload if the pics dont help ya.

The question is this:
On the Sales sheet, using formulas display the sales $ for each type of stock (beer, Coffee, Muffin etc etc) for each month in the lower table using sumif.

Please help me


http://img4.imageshack.us/img4/5478/part1gt.jpg
http://img691.imageshack.us/img691/7919/part2x.jpg

http://www.megaupload.com/?d=HE2R36MP

[zbor]

Just add NAME in Pivot table below TYPE.

Is this it?

[rockamania]

Just add NAME in Pivot table below TYPE.

Is this it?

Im sorry im not following you....

[ConneXionLost]

Hi rockamania,

Couldn't tell how far down the list goes on your "Stock" sheet, so you'll need to adjust the ranges as required (change the 30 to the last used row number), but use these formulae as described:

In cell B25 paste this formula:

Please Login or Register  to view this content.

In cell C25 paste this formula:

Please Login or Register  to view this content.

In cell D25 paste this formula:

Please Login or Register  to view this content.

In cell E25 paste this formula:

Please Login or Register  to view this content.

Once pasted, highlite these four cells, and autofill them down to row 37.

Cheers,

[teylyn]

rockamania,

this forum has a convenient way of uploading files right into your post. There is no need to use an external service that charges a premium if you don't want to wait for up to 5 minutes before you are granted a download slot.

For your next file attachment, please click "Go Advanced" below and then the paper clip icon to attach a file.