View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Vanessa Simmonds Vanessa Simmonds is offline
external usenet poster
 
Posts: 17
Default Sum Valour From different Columns

Hi,

I need help once again.

I am working with two worksheets in each I have sales valour for differents
segments. Which of them has more ou less 200 rows.

I am to created a thirth worksheet which I will use to consolidate the
valour from the first two.

Example:

Worksheet one Worksheet two
Column 1 Column 2 Column 1
Column 2
Water 10 Paper
01
Paper 15 Water
05
Detergents 05 Water
07
Water 01 Detergents
02

Worksheet Three
Column 1 Column 2
Water 23
Paper 16
Detergents 07

Is it possible?

Thank you very much,

Vanessa