help

[KisH \(Tihomir\)]

Hello,
I have sheet1 and sheet2
sheet1
A B
1 text1 2
2 text2 3
3 text1 5
4 text1 1

sheet2
A B C
1 text1 10
2 text2 10

Formula in C1 (sheet2) needs to SUM all numbers from column B (sheet1) which
are corresponding to value "text1" from A1 (sheet2).
example:
value of A1(sheet2) is "text1" and formula in C1(sheet2) will SUM
from sheet1 all numbers which are next to word "text1", in this case
2 + 5 + 1 =8 , so formula in C1(sheet2) will return 8.


Can this be done without a macro?
Please help.
Thank you.

 

[Sandy Mann]

I don't unsedstand where the 10's in Sheet 2 come from but to do what you
say in the text try:

=SUMIF(Sheet1!$A$1:$A$4,A1,Sheet1!$B$1:$B$4)

with Text1 in A1 of Sheet2 and then drag down on the fill handle.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[KisH \(Tihomir\)]

I don't unsedstand where the 10's in Sheet 2 come from but to do what you
say in the text try:

=SUMIF(Sheet1!$A$1:$A$4,A1,Sheet1!$B$1:$B$4)

with Text1 in A1 of Sheet2 and then drag down on the fill handle.

Problem was solved yesterday with that formula you writed now
Thank you anyway.