the number of people in that family who are aged over 18 (actually it
needs to contain "17" not "18" to work correctly!)

Then your criteria isn't "who are aged over 18". Maybe you meant "who are
aged 18 and over".

17...17...18

=INDEX(FREQUENCY((D4,F4,H4),18),2)

Returns 0 - no age *over* 18

=INDEX(FREQUENCY((D4,F4,H4),17),2)

Returns 1 - 1 age 18 and over

--
Biff
Microsoft Excel MVP


"Lobster" wrote in message
...
T. Valko wrote:
One way...

=INDEX(FREQUENCY((D4,F4,H4),18),2)


Wow - that was quick, and such an simple formula! I've been scratching my
head with massive long IF statements and getting nowhere (not
surprisingly).

Thank you so much!
David

(actually it needs to contain "17" not "18" to work correctly!)