Count fields and show 1 or 0

  • Thread starter Thread starter slagg7575
  • Start date Start date
S

slagg7575

OK guys, I have another problem I will post here and on another post if
nobody reads this.

I have the same 5 (A2:E2)fields, each with a 1 or 0. What I need this
time is that If A2 is 1, then I need A2 plus any 2 (1or true) of the
remaining four (B2:E2), to them have the new field box called total to
read 1 or true. If A2 is 0(false), then regardless of the other four,
the Total field must read 0 or false. Does this make sense? Thanks
again!
 
Hi,

Wow thanks for the speedy reply! It works like a charm...thanks again
Roger! I may have some more questions later...but thanks again...your
help is greatly appreciated!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA - counting cells by colors and names to it in two different rows. 0
Pivot table calculated field Count(field) / sum(field) 0
SUM HELP PLZ 3
Count fields and show names 5
Excel Add 60 days to column 1 or column 2 based on whether column 2 has data 1
What formula can one use to Count dates? 8
Check colume if it is not blank 3
Sumproduct with if statement 4

Back
Top