Excel 2007 : How to- If statement resulting in value in cell summed in another cell

[Rudsud]

I'm not even sure how to ask the question

I have a list of parts that are sorted by part #. Within this list there are different alloys of parts (8 alloys total Alloy column E2:E150).

One column is updated by me on a daily basis and this changes the amount of lbs left to make for the month (which shows in cell S2:S150).

I want to create a statement that performs:

IF "Alloy" in E2 equals 6-2-4-2, put value in S2 into cell V5. I want all of the 6-2-4-2 values to total in cell V5.
AND IF "Alloy" in E2 equals BC, total values in S2:S150 into cell V6
AND IF "Alloy" in E2 equals 6-4 DM, total values in S2:S150 into cell V7
AND IF "Alloy" in E2 equals 6-4 PWA, total values in S2:S150 into cell V8

Any help would be greatly appreciated!

[JBeaucaire]

Aren't these just 4 different formulas?

V5: =IF(OR(E2="", E2<>"6-2-4-2"), "", SUM($S$2:$S$150))
V6: =IF(OR(E2="", E2<>"BC"), "", SUM($S$2:$S$150))
V7: =IF(OR(E2="", E2<>"6-4 DM"), "", SUM($S$2:$S$150))
V8: =IF(OR(E2="", E2<>"6-4 PWA"), "", SUM($S$2:$S$150))

[Rudsud]

The formula would be in S2-S150. I need all that to go in one formula and spit the results out into V5,V6,V7,V8.

[JBeaucaire]

That's not how worksheet formulas work. If you want different results in those cells, each would need its own formula. According to your OP, I believe the formulas I gave do that.

[Rudsud]

OK, I see what you are saying. I paste the formula and the cell is blank. Am I supposed to fill in those empty quotes?

[JBeaucaire]

If the formula results in null values, then that column is supposed to be blank. Only the formula that gets a match to the text string in E2 will get a SUM() for it's cell. All the others should be blank.

Properly inserted, only one of the 4 cells will give an answer, or none if E2 fails to match any of them.

Post up a sample worksheet showing examples of all the matched values, if you keep having difficulty.

Click GO ADVANCED and use the paperclip icon to post up your workbook.