Here's what I'm trying to do. I have a list of 128 objects (placed in the rows) and 14 potential properties (placed in the columns) that they could contain. For each object (row) I have simply entered a 1 if it contains the given property (column) or a 0 if it does not. What I want to be able to figure out is how many of the rows do not contain any of two of the properties. In essence I want determine how many of the rows contain a 0 in both of the relevent columns (L and N in this particular case). Any help would be amazing!
In 2007?
Try COUNTIFS
=COUNTIFS(L:L,0,N:N,0)
Audere est facere
That did it. Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks