In an excel document I have a series of data values split into columns (let us use columns A-F for simplicity). Each row represents a new person to count.
I would like excel to count a person if any of the values in their row in columns A through to F is greater than 0. Regardless of the number in any column, if it fulfills the criteria, I only want it to count the person once.
I have tried to use COUNTIF and COUNTIFs functions but I can't seem to get the formula to resolve properly.
To make this clear, I am trying to create a formula that: Counts the number of rows where one or more cells in columns A-F has a value greater than 0.
Thanks for the assistance!
Bookmarks