Excel spreadsheet

Hi Mahua,


Thank you for your question.

To count up the number of different responses you have in your spreadsheet you would need to use the 'countif' function.

1. Type into the cell where you require the answer, =countif(

2. Highlight the range of cells that have the different responses (i.e the 2's/3's) and then enter a 'comma'

3. Then type in "=2" to count how many 2's you have in that range. You would need to replace that with "=3" to count how many 3's you have in that range.

so your formula would look something like:
=countif(B2:B20,"=2")


I hope this helps. If it has, please mark this question as resolved.


If you require further assistance, please reply to this post.


Have a great day.

Regards,


Nafeesa

Microsoft Office Specialist Trainer