LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 6
Default Membership list: column for no. of over 18s?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Membership list nickodemos Excel Discussion (Misc queries) 0 April 26th 09 11:39 PM
Club membership list / database Monte Milanuk[_2_] Excel Discussion (Misc queries) 6 November 14th 08 11:48 AM
Membership List Marge at large New Users to Excel 3 September 3rd 08 07:06 AM
Determinig Population membership percentages Michele Excel Worksheet Functions 1 June 30th 06 05:57 PM
Group membership jamex New Users to Excel 2 March 9th 06 01:07 PM


All times are GMT +1. The time now is 03:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"