Wanting to simplify this formula - new to forums, happy to be told where/how i should be posting

[ScrivenerG]

Hi i knocked up this formula to get the sum of a columnof cells only if the values in the cells next to them were less than 20.

=(IF(J15<20,K15,0)+IF(J16<20,K16,0)+IF(J17<20,K17,0)+IF(J18<20,K18,0)+IF(J19<20,K19,0)+IF(J20<20,K20,0)+IF(J21<20,K21,0))

I'm sure there's a way of condensing it but can't make it work.
Excel novice.
Forum novice.

Many thanks

 

[Marcílio_Lobão]

ScrivenerG, Good evening.

Try to use:

=SUMIF(J15:J21, "<20", K15:K21)

Is that what you want?
I hope it helps.

Ps.: Take a look at it:https://support.office.com/en-us/article/SUMIF-function-169b8c99-c05c-4483-a712-1697a653039b

 

[ScrivenerG]

perfect thank you very much

 

[Marcílio_Lobão]

Thanks for the feedback.

Glad to help you!