Example;
A E
Last Name Departing 10Jul
Smith x
Jones
Jackson x
Johnson x
Alexander x
x
My sheet has 182 rows and I do not care what someones name is, hence the use of the COUNTA to calculate number of personnel. However, I only want the personnel in column A "Last Name" counted that has a corresponding "x" in column E "Departing 10Jul".
why don't you just count all the x's in the 'departing' column?
=countif(b:b,"x")
- i.s.z -
CSE, aka Array aka { }, formulae are confirmed with CONTROL+SHIFT+ENTER.
Replace commas ( , ) with semicolons ( ; ) in formulae, if your locale setting demands.
All good ideas are courtesy resources from this forum as well as others around the web.
- e.o.m -
Because the roster is a living document, meaning it will have changes to both columns before final validation, so it is easier to track numbers by establishing set formulas.
sorry, that explanation did not hit home. anyway, another approach:
since you are on version 2007, try 'countifs':
=countifs(a1:a100,"<>"&"",b1:b100,"x")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks