I am creating a workbook and need some help.

Sheet 1 is where I enter data (qnty of products made is then broken down
into its composite parts and their qnty) eg below

CELL A1 = CASES MADE = 1

CELL A3 = CASE TYPE A = 1
CELL A4 = LABEL TYPE A = 2
CELL A5 = CASE LINER A = 1
CELL A6 = OTHER ITEM A = (NO FIGURE INPUT)

I would enter the same type of info for several products each using the same
components.

I would like to summerise the total qnty's on a seperate sheet to print out
Only those items that have a figure input next to them. to look like the
example below

HEADING = TOTAL QNTY'S USED

CASE TYPE A 100
LABEL TYPE A 25
CASE LINER A 100

I hope someone has an idea of how to do this.

Thanks

Julian

Simple way:
Add a new sheet (printme)
set it up and format as you wish
in the cells that require sum data from other sheet ("DataSheet")

use =sum(DataSheet!A1:IV1)

by the way columns are limited but 30,000+ rows so if you may have 250
items you need to rotate so that your items are in columns and the count is
in the rows.

"Julian Campbell" wrote:

I am creating a workbook and need some help.

Sheet 1 is where I enter data (qnty of products made is then broken down
into its composite parts and their qnty) eg below

CELL A1 = CASES MADE = 1

CELL A3 = CASE TYPE A = 1
CELL A4 = LABEL TYPE A = 2
CELL A5 = CASE LINER A = 1
CELL A6 = OTHER ITEM A = (NO FIGURE INPUT)

I would enter the same type of info for several products each using the same
components.

I would like to summerise the total qnty's on a seperate sheet to print out
Only those items that have a figure input next to them. to look like the
example below

HEADING = TOTAL QNTY'S USED

CASE TYPE A 100
LABEL TYPE A 25
CASE LINER A 100

I hope someone has an idea of how to do this.

Thanks

Julian