Hi all,
first time in this forum, hope that you could help me.
I have 2 sheets "A" and "B".
on A,
<tbody>
</tbody>
On B,
<tbody>
</tbody>
Is there any countifs + index match formula which i could write on XX on Sheet A, which will count the number people with Apple,Pear...(not SUM of apples) from Sheet B?
*I want something like Countifs(Apple,">0") but with a reference so that next time i could just modify/add the fruit name on Sheet A and it will automatically find from Sheet B.
Thanks!
Yoshi
first time in this forum, hope that you could help me.
I have 2 sheets "A" and "B".
on A,
Apple | XX |
Pear | XX |
Orange | XX |
Grape | XX |
Peach | XX |
<tbody>
</tbody>
On B,
Name | Apple | Pear | Orange | Grape | Peach |
Jack | 1 | 0 | 0 | 1 | 1 |
Peter | 2 | 1 | 2 | 0 | 0 |
Daniel | 1 | 4 | 0 | 2 | 1 |
John | 2 | 1 | 1 | 1 | 1 |
David | 1 | 2 | 0 | 0 | 0 |
<tbody>
</tbody>
Is there any countifs + index match formula which i could write on XX on Sheet A, which will count the number people with Apple,Pear...(not SUM of apples) from Sheet B?
*I want something like Countifs(Apple,">0") but with a reference so that next time i could just modify/add the fruit name on Sheet A and it will automatically find from Sheet B.
Thanks!
Yoshi