Counting multiple columns without double counting

[soozler]

I have a spreadsheet with six columns and 80,000 thousand rows.

Each row is a record. There are three columns "participated, lead, volunteered".

We need a formula that will tell me that total number of records that did ONE of the Three things.

So I can't simply sum count if functions, because someone could have Participated, Volunteered, and Lead. If they did all three excel should still only count it as 1 record.

Any help?

 

[ChrisM]

Easiest way is to create a new helper column. Use the following formula in each row:

=If(Count(A1:C1)>0,1,0)

Then just sum that new column.

 

[soozler]

Brilliant. TY