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...