How do I count the number of people used in these formulas?
In the attached worksheet - on the analysis tab -
In D12 I'd like to have a count of how many individuals comprise the average in formula B12?
Also, for each cell of B24 to E36 - how many individuals are in each formula?
Take your formula from B12 and paste it into D12.
Remove the first argument (the red bit below).
=AVERAGEIFS(Data!$G$2:$G$100,Data!$C$2:$C$100,"M",Data!$D$2:$D$100,"Apple")
Then change AVERAGEIFS to COUNTIFS.
=COUNTIFS(Data!$C$2:$C$100,"M",Data!$D$2:$D$100,"Apple")
The same approach would count for the others.
BSB
Hi
in D12 to be confirmed with control+shift+enter
=SUM(IF(FREQUENCY(IF(Data!C$1:C$100="M",IF(Data!D$1:D$100="Apple",MATCH(Data!A$1:A$100,Data!A$1:A$100,0))),ROW($1:$100)),1))
It should do the trick.
Last edited by canapone; 05-05-2019 at 03:09 AM.
-----------------------------------------------------
At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.
Please, mark your thread [SOLVED] if you received your answer.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks