Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I'm updating a club membership list in Excel at the moment.
Each member (or family membership) has a single row and the dates of birth (and current ages calculated therefrom) are displayed in individual cells. What I'm trying to do now is create another column in the spreadheet, headed "Number of over 18s" (ie, the number of people in that family who are aged over 18). So, if columns D, F, and H contain the ages of 3 people, what formula do I need to put in my new column, K? (ie, if cell D4 is 53, cell F4 is 50, and cell H4 is 15, then the output displayed in cell K4 would be "2") Thanks for any help David |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Membership list | Excel Discussion (Misc queries) | |||
Club membership list / database | Excel Discussion (Misc queries) | |||
Membership List | New Users to Excel | |||
Determinig Population membership percentages | Excel Worksheet Functions | |||
Group membership | New Users to Excel |