CountIfs not Working - Need Help

[hemanthb]

Hi,

On Sheet 1, I have a list of keywords in column A, Ranking positions in column B and the keyword category in column C.

I am trying to create a position spread of how many times a Category appears in Positions 1 - 3, Positions 4 - 10, Positions 11 - 20, Positions 20+.

I have written CountIfs in Sheet2 but the values are displaying as 0. Could you please help. What am I doing wrong here.

[windknife]

You chose wrong column.
Try this in B2, others are like this.

Please Login or Register  to view this content.

[hemanthb]

Thank you... It worked. I had the sheet reference wrong. Sheet1!D:D instead of Sheet1!C:C.

[windknife]

You are welcome.