# 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
###### Who is Participating?

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Enterprise ArchitectAuthor Commented:
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)
0
Commented:
If you don't like to use calculated column then you might want to use info path designer.
use the same list form but just write the logic in behind. Update the field by adding logic on when a  one of the field is Yes then update a random text field and use that.
Another option is write a SharePoint designer workflow and do the same check the value and update another text field which you are using as a calculated field.
If there is lot of logic then better use other options.
0

Experts Exchange Solution brought to you by