Excel: Counif function


How to calculate the total fruits consumed by 3 students within 5 days ? Please take note each student can consume more than 1 per day ?

Student 1 Student 2 Student 3
Day 1 apple / kiwi orange apple
Day 2 orange honey dew apple / kiwi
Day 3 kiwi apple orange
Day 4 honey dew / kiwi kiwi kiwi
Day 5 apple kiwi apple
Final Output Apple : 6 Kiwi : 7 Orange : 3 Honey Dew: 2


This question generated 26 answers. To proceed to the answers, click here.

This thread is current as of October 10, 2013.


For more resources for Microsoft Excel