Shorten Formula =IF(D8=5,L8,0)+IF(D9=5,L9,0) repeat unto row 209 +IF(D209=5,L209,0)

[MStacey]

I

 

[MStacey]

I am trying to look at Rows i8 to 209 in n Column D and if they contain the value 5 then take the value in corresponding row 8-208 in Column L and add them all up. Is there a better way to do this with a shorter forumla please

 

[Rick Rothstein]

Try using the SUMIF formula...

=SUMIF(D8:D209,5,L8:L209)