Formulas and Functions

New Contributor

Please help in population relevant formulae to the attachment

2 Replies
I have extracted just 5 lines from a big file, which I need to interrogate. I need to combine the IF and COUNTIF formulae. The question will be: If the data in the range if female, then use the next column and indicate which are adults
best response confirmed by Boipelo2808 (New Contributor)

@Boipelo2808 The easiest would be to create a pivot table. The output is not in the same lay-out as what you described but perhaps you can work with it anyway. See attached.