Counting Data on another Worksheet

///////////////////

Hi James,

Welcome to the forum.

Try using below formula:-

{=SUM((Data!$A$1:$A$21='Score Board'!$A2)*(Data!$B$1:$B$21="10-- Extremely likely"),(Data!$A$1:$A$21='Score Board'!$A2)*(Data!$B$1:$B$21=9))}

above formula need to be entered with key combination ctrl + shift + Enter


See attached:- Scorecard.xlsx

Regards,
DILIPandey

<click on below 'star' if this helps>

Or with an pivot table.

dilipandy, thanks for the worksheet.

You are welcome...

Cheers

Please mark this thread as [SOLVED].. thanks,

Regards,
DILIPandey

<click on below 'star' if this helps>

Hi,

From my question I'm trying to get how many customer provided the answer 0-- Not likely at all and 6 on Worksheet named Data and placed it on Column D, what would be the best formula that I can do if I want to get how many customer provided the answer 0-- Not likely, 1, 2, 3, 4, 5 and 6 and placed it on column D. Meaning the range is 0-- Not likely up to 6.

Greatly appreciate your assistance on this one.

Okay.. it would be better if you can share a workbook sample for this. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

Here's the workbook sample

Attachment 178234

Done..!!

See the attached file. thanks.
Scorecard_new_backup.xlsx


Regards,
DILIPandey

<click on below 'star' if this helps>

You are welcome..

Cheers

regards,
DILIPandey

<click on below 'star' if this helps>