Count function to show what fields counted

[slagg7575]

Hello all,

I have an excel spreadsheet that has 5 fields (cells-HIP, WAIST, ARM,
LEGS, HEAD) each with a value of 1 or 0 (True or False)
I need a formua to count the 5 fields and if there are 3/5 that are 1
(True) then fill a new cell (Total) with 1(True), if there are less
than 3 fields, then False (0). But would it also be possible to show
which fields, along with the value of 1 or 0, were true and which were
false?
For example,

3/5 fields--->True False
HIP, WAIST, HEAD ARMS, LEGS

Thanks a million for you time!

 

[Max]

Here's one play fashioned that might suit what you have in mind ..

Assumptions:
Col headers placed in A1:E1 : HIP, WAIST, ARM, LEGS, HEAD

Input range per line (in cols A to E from row2 down) will contain
either a 1 or 0. There will be no cells left blank within the input
range for any line.

Result col headers placed in G1:I1 : Total, TRUE, FALSE

In G1:
=IF(COUNT(A2:E2)<5,"",IF(SUM(A2:E2)>=3,1,0))

In H1:
=SUBSTITUTE(TRIM(J2&" "&K2&" "&L2&" "&M2&" "&N2)," ",", ")

In I1:
=SUBSTITUTE(TRIM(O2&" "&P2&" "&Q2&" "&R2&" "&S2)," ",", ")

In J2, copied across to N2:
=IF(A2=1,A$1,"")

In O2, copied across to S2:
=IF(A2="","",IF(A2=0,A$1,""))

Select G1:S1, copy down as far as desired. Hide away cols J to S.

 

[Max]

Here's a sample construct to illustrate the foregoing (nicely rendered!
<g>):
http://cjoint.com/?iEeSTtIiSH
Count and display col headers template.xls
[Link above is good for 14 days]