Conditional Sum

[Travis]

Im trying to sum column B based on the values in column A. For example, using the table below I want the sum of the values in column B, where there is a 1 in coumn A. So in this case the result would be 5+7=12
A B
1 5
2 10
1 7
3 8

I used the conditional sum wizard which works and puts this in the cell:
{=SUM(IF($A$2:$A$5=1,$B$2:$B$5,0))}
but I cant copy it or modify it because it removes the outside brackets...Im not sure what those are for...I need to do this about 50 different ways and didnt want to use the wizard every time.

Please help, thanks
Travis

 

[zzydhf]

Welcome to the board!
sumif is an excel function, so for 1 criteria the Ctrl+Shift+Enter is not needed. Just use:
=SUMIF(A2:A5,1,B2:B5) hit enter. (modify as needed)

If more than 1 criteria is needed, then it becomes a CSE formula

 

[Mark W.]

The outermost braces are automatically added when you array-enter the formula using the key combination...

Control+Shift+Enter

For more information about array formulas see the Excel Help topic for "About array formulas and how to enter them".