Hello, I've got stuck and can't find the answer anywhere...
I have a data set from a survey which tells me how many people of different age ranges they have in their household.
In order to calculate the number of households with adults between 16 and 64 and dependents who are under 16, I would like to use a forumula that counts all the instances where there is a value in columns D to G (green in the attached), i.e. each household IF there is a value in the corresponding cells A to B (yellow in the attached).
I'm pretty sure I should be able to do this but have tried all sorts, to no avail.
Here are some of the forumals I've tried:
=IF(D2:G875,"<>"),AND(B2:C875,"<>"),COUNT(D2:G875)
=IF(B2:C875,"<>"),counta(D2:G875)
=countif(D2:G875,"<>"),(B2:C875,"<>")
These all return a 'There's a problem with this formula' errors.
Can anyone help?
Thanks!
Bookmarks