help

  • Thread starter Thread starter KisH \(Tihomir\)
  • Start date Start date
K

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.
 
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
 
Sandy Mann said:
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.
Click to expand...

Problem was solved yesterday with that formula you writed now :)
Thank you anyway.
 
Back
Top