Link to home
Start Free TrialLog in
Avatar of Matt Pinkston
Matt Pinkston

asked on

Calculated FIeld (How many columns are Yes)

Looking for some assistance on a SP Calculated field....

I have 26 fields F01 -- F26 that are simple drop downs Yes or No
I need to count how many times F01 - F26 are set to yse with a Calculated field.....

Thanks

I use
=COUNTA(F01,F02,F03,F04,F05,F06,F07,F08,F09,F10,F11,F12,F13,F14,F15,F16,F17,F18,F19,F20,F21,F22,F23,F24,F25,F26)
To see how many times they are non-blank
Avatar of Matt Pinkston
Matt Pinkston

ASKER

Tried this but did not like it
IF([F01] = "YES", 1, 0)+ IF([F02] = "YES", 1, 0)+ IF([F03] = "YES", 1, 0)+ IF([F04] = "YES", 1, 0)+ IF([F05] = "YES", 1, 0)+ IF([F06] = "YES", 1, 0)+ IF([F07] = "YES", 1, 0)+ IF([F08] = "YES", 1, 0)+ IF([F09] = "YES", 1, 0)+ IF([F10] = "YES", 1, 0)+ IF([F11] = "YES", 1, 0)+ IF([F12] = "YES", 1, 0)+ IF([F13] = "YES", 1, 0)+ IF([F14] = "YES", 1, 0)+ IF([F15] = "YES", 1, 0)+ IF([F16] = "YES", 1, 0)+ IF([F17] = "YES", 1, 0)+ IF([F18] = "YES", 1, 0)+ IF([F19] = "YES", 1, 0)+ IF([F20] = "YES", 1, 0)+ IF([F21] = "YES", 1, 0)+ IF([F22] = "YES", 1, 0)+ IF([F23] = "YES", 1, 0)+ IF([F24] = "YES", 1, 0)+ IF([F25] = "YES", 1, 0)+ IF([F26] = "YES", 1, 0)
ASKER CERTIFIED SOLUTION
Avatar of Uttam (Kukdai) Dhakal
Uttam (Kukdai) Dhakal
Flag of United States of America image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of Fredd
Fredd
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Fredd
Fredd
Solution and warning about SP limits given