If formula for more that 300 targets

HI all,

i have an IF formula that reads =if(a32="u",h32,0)+if(a33="u",h33,0)+ for another 300 lines......

is there a quicker way to make this happen rather that manually do each line?

please advise

Try Sumif

=SUMIF(A32:H332,"u",H32:H332)

=SUMIF(A32:A332,"u",H32:H332)

sorry guys - i need to be way more specific. cells L363:T363 and L362:T362 are all if formulas based on column F and G AND the socring in the green box beside it. the vlookp and sum if wont work becuase there are header rows with the "u" or the "na" in them and they cant be counted.

please see the attachment to make it all make sense...

so you want to sum everything without a u? What are you actually trying to do?

what it is doing at the bottom of the "green" section - is totaling the amount of points that are associated with a U or an NA. what i have done right now is manually choose which cells to look at the if statement. however i need to change this to allow for changes in the future as to where scoring is allocated

So what defines a point that is associated with a U or an NA.

From looking at the attached sheet, the total in L361 is summing everything above it apart from L316, L351 and L326.

So if you summed everything apart from the rows which held the "10. Breakfast", "10. Breakfast - Total" and "11. Purblendz - Total" rows would that do?

Maybe in L361:
=SUM(L25:L360)-VLOOKUP("10. BREAKFAST - TOTAL", B25:L360,11,FALSE)-VLOOKUP("10. BREAKFAST",B25:L360,11,FALSE)-VLOOKUP("11. PURBLENDZ - TOTAL",B25:L360,11,FALSE)

? It returns the same as what you have at the moment..

that gives a total count - not only the count based on column g having a "u" in it - thanks for your help!

try putting a U in a few cells in the G column - the numbers will adjust on L depending on what is linked with the if formula.

the count should only happen if a NA or U is present in column F and G

AZ_XL!! thank you!!! fantastic