Sum Valour From different Columns
Hi Vanessa,
If i understood what are you looking for use on ws 3:
=sumproduct(--(ws1!a2:a100="water"),(ws2!b2:b1000))+sumproduct(--(ws2!a2:a100="water"),(ws2!b2:b1000))
hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo
"Vanessa Simmonds" escreveu:
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
|