Add value to total depending on content of cell

[[email protected]]

Hi all.
I have a problem that I'm finding difficult to find an answer for.

the problem I have is that I want cell (Sheet 3; C4) to contain a sum of values from (sheet 1; column E),
and here is the catch,
IF (Sheet 3; C5) has a value that can be matched to a corresponding row cell in (sheet1; column B).

So..... If I put the value 302 into cell (sheet 3; C5) I want the spreadsheet to go and find 302 in (sheet 1; column B) and then add the value it finds in
(sheet 1;column E) on the same row to cell (sheet 3; C4)
BTW. cell (sheet 3 ;C5) will look something like (302, 304, 750).

I hope this makes sense.

The problem is how to describe the problem I have.....

[:) Sixthsense :)]

Enter those conditions within the formula

In C4 Cell of Sheet3

=SUM(SUMIF(Sheet1!B:B,{302,304,750},Sheet1!E:E))

[[email protected]]

Sixthsense. Thanks for the quick reply. and your solution does give me some things I didn't know.
However.... the test is that add the value only if sheet 3; C5 contains a certain value, 302 in my example.
So somewhere it's going to need something like (IF C5 contains 302,304,750)....

[:) Sixthsense :)]

I am unable to follow

[[email protected]]

OK. Sorry its my fault for not being able to describe my problem....
I will try again... the logic is.
I add a string to (sheet 3; C5) - for example "301", and I need the spreadsheet to find this string in (sheet 1; column B) and then add the corresponding value found in (sheet 1;column E) to the value of (sheet 3; C4).

O I think I will just do it with a pencil.....

[:) Sixthsense :)]

Try this…

In C4 Cell of Sheet3

=SUMIF(Sheet1!B:B,C5,Sheet1!E:E)

[[email protected]]

OOOO so close.
It works for one value, however, and again this is my fault for not explaining properly, the cell (sheet 1;C5) will contain 301, 302, 720, ....etc. and I want C4 to be the addition of all of these lookups into sheet 1.
I was thinking I could do it with.
=SUMIF(Sheet1!B:B,C5={301, 301, 720, , , , },Sheet1!E:E) ???

[[email protected]]

Sorry that should have read (sheet 3;C5) will contain.....

[:) Sixthsense :)]

In C4 Cell of Sheet3

=SUMPRODUCT(SUMIF(Sheet1!B:B,C5:C10,Sheet1!E:E))

Instead of keeping the values 301, 301, 720 in a single cell with comma separated, just enter each values in each cell from C5:C10 of sheet3 without comma. Extend the range C5:C10 based on your input requirement.