I'm trying to figure out a formula to for columns D through L to see if the number in those columns is under 30, and if it is, then I want it to add how many in those rows are under 30 and put that number in the corresponding row.
So far I have: =IF(D1176:L1176<30,
And I'm not sure how to get that to add how many in the row are below 30. For example, D1176 is 28, E1176 is 3, F is 10, G is 40 and so on...so that's 3 out of the 4 that are under 30 so I would want number 4 in C1176.
Please help!
