Hi,
I'm wanting to know how many "clients" are in each "category or combination of categories" (signed, sent, prospective). Each column represents the number of contracts/services for each client. It doesn't matter the number, just as long as it's not 0. How do I count "signed" & "sent" without duplicating the count if a client has signed 1 contract, but has another sent?
Book.xlsx
Last edited by dgroff; 12-09-2014 at 02:58 AM.
Bump no response
I'm not sure if I'm making sense. Sorry, if it's confusing...
Basically count the number of cells in multiple columns by row that are greater than 0, but don't add the values... So if both Columns C & D have a number in row 4, then row 4 would count as 1.
I need a formula that does this with 2 columns and another that does it with 3 columns.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks