SUMIF questions

Hey there everyone.
Excel is not my forte, but I need to create some formulas that add cells together if they match a particular number.
ie, if cell a1 = 1, and if cell a2 = 1, etc, the add them together and display the total (the cells could have a 1,2,3,4,5 in them, but I only want to add together the ones with "1" in them)
This is what I have and it gives me a #NAME? result:
=SUMIF(U2:BL2,1,(sum_range))
Please let me know where I'm going wrong...

Hi There;

Sticking to your small example, the complete formula should be;

=SUMIF(U2:BL2,1,U2:BL2)

If you're going to need two dimensional SUM, you should go with SUMIFS function.

Hope this helps.

tac

Thank you - that works. I see where I went wrong then!