Results of SUM and IF statement in FormulaBuilder correct, but not in cell

[newtoformulas]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I have two columns one with numbers (column a), the other with text that relates to that number value(column b). I want to extract all of the same items in column b and sum up the corresponding numbers from column a into one cell. I am using this formula below, which produces the correct resulting summed valued in the Formula Builder box, but the actual cell remains zero. Any advice? Here is the formula I used:

=SUM(IF(B1:B10=D2,A1:A10,0))

Thanks for any advice!!! John

 

[Bob Greenblatt]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I have two columns one with numbers (column a), the other with text that
relates to that number value(column b). I want to extract all of the same
items in column b and sum up the corresponding numbers from column a into one
cell. I am using this formula below, which produces the correct resulting
summed valued in the Formula Builder box, but the actual cell remains zero.
Any advice? Here is the formula I used:

=SUM(IF(B1:B10=D2,A1:A10,0))

Thanks for any advice!!! John

Try changing D2 to $D$2

 

[JE McGimpsey]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I have two columns one with numbers (column a), the other with text that
relates to that number value(column b). I want to extract all of the same
items in column b and sum up the corresponding numbers from column a into one
cell.

One way:

=SUMIF(B1:B10, D2, A1:A10)

Note that your formula would work if you array-entered it (use
CMD-RETURN instead of just RETURN).

 

[newtoformulas]

Thanks for the answers! This worked!