Formula Help

%3CLINGO-SUB%20id%3D%22lingo-sub-2617064%22%20slang%3D%22en-US%22%3EFormula%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2617064%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20trying%20to%20figure%20out%20a%20formula%20to%20for%20columns%20D%20through%20L%20to%20see%20if%20the%20number%20in%20those%20columns%20is%20under%2030%2C%20and%20if%20it%20is%2C%20then%20I%20want%20it%20to%20add%20how%20many%20in%20those%20rows%20are%20under%2030%20and%20put%20that%20number%20in%20the%20corresponding%20row.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20far%20I%20have%3A%26nbsp%3B%3DIF(D1176%3AL1176%26lt%3B30%2C%3C%2FP%3E%3CP%3EAnd%20I'm%20not%20sure%20how%20to%20get%20that%20to%20add%20how%20many%20in%20the%20row%20are%20below%2030.%20For%20example%2C%20D1176%20is%2028%2C%20E1176%20is%203%2C%20F%20is%2010%2C%20G%20is%2040%20and%20so%20on...so%20that's%203%20out%20of%20the%204%20that%20are%20under%2030%20so%20I%20would%20want%20number%204%20in%20C1176.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20help!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2617064%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2617125%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2617125%22%20slang%3D%22en-US%22%3Ein%20cell%20C1176%3A%20%3DCOUNTIF(D1176%3AL1176%2C%22%26lt%3B30%22)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2617142%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2617142%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1121659%22%20target%3D%22_blank%22%3E%40sml91%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DCOUNTIF(D1176%3AL1176%2C%22%26lt%3B30%22)%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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!

 

3 Replies
in cell C1176: =COUNTIF(D1176:L1176,"<30")

@sml91 

=COUNTIF(D1176:L1176,"<30")

Amazing!!! Thank you so much - this worked