Hi guys, been stuck on this for a while now, any advice would be appreciated! (EXAMPLE attached)
The column "Child Count" must return 1 if:
1. Child is under brand name A or B and is older than 1 but younger than 13
2. Child is under brand name C and is older than 1 but younger than 12
Originally in the child count column I put the formula:
=COUNTIFS(F2,">1", F2,"<13")
...but of course this only counts children for Brands A and B.
Try this...
Formula:
Please Login or Register to view this content.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks