Counter for multiple columns

Urrme

New Member
Joined
Jun 9, 2014
Messages
20
Hi, I want to know if I can make a formula in a simple way for multiple columns

I want to know I have results in 18 columns, A3:R3 I want to know, on row 3, if 9 columns show values of 14 or over.
I want the result to be shown in one cell, U3. And I want U3 to display 9 when 9 of the 18 columns show a value of 14 or over. But I want it to display 10, if 10 columns show a figure of 14 or over (A3:R3

And so on.

Is there a way to make the cell blank in U3 if there are not at least 9 columns showing values of 14 or more?

Thanks very much.
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

Forum statistics

Threads
1,223,738
Messages
6,174,213
Members
452,551
Latest member
croud

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top