how to select and count from a range of data

I have 3 data sheets:
Sheet1, sheet2, sheet3
From Sheet1 a value V1 is taken and looked up in Sheet2 another value
corresponding to V1 ia taken say V2 (I tried doing this by Vlookup and am
able to do find V1 and take V2) and V2 is checked in Sheet3 in data which is
arranged horizontally and under this value I have a lot of values in the same
column.

I want to select this range of data and then count the number of cells for a
particular value.
How can i do it ?

assumed sheet 1 - value V1 = xyz
same value is been looked in sheet 2
e.g., sheet 2
col V Col W
abc 123
xyz 456
cbz 789

by looking up for xyz in sheet 1 value result will be 456 and same
number
is been looked up sheet 3 and u need to count that number ? Is this
you are looking for

I guees u need count function

=COUNTIF(sheet3!V2:Y2,sheet1!V2)

On Dec 6, 5:32*pm, Ajay wrote:
I have 3 data sheets:
Sheet1, sheet2, sheet3
From Sheet1 a value V1 is taken and looked up in Sheet2 another value
corresponding to V1 ia taken say V2 (I tried doing this by Vlookup and am
able to do find V1 and take V2) and V2 is checked in Sheet3 in data which is
arranged horizontally and under this value I have a lot of values in the same
column.

I want to select this range of data and then count the number of cells for a
particular value.
How can i do it ?

suppose for 456
123 456 789
a b c
d b a
b a c

I want to count b's under 456

I can use countif(sheet3!V2:Y2,"b") but how do i get that V2:Y2 refers to
the data below 456 only


"muddan madhu" wrote:

assumed sheet 1 - value V1 = xyz
same value is been looked in sheet 2
e.g., sheet 2
col V Col W
abc 123
xyz 456
cbz 789

by looking up for xyz in sheet 1 value result will be 456 and same
number
is been looked up sheet 3 and u need to count that number ? Is this
you are looking for

I guees u need count function

=COUNTIF(sheet3!V2:Y2,sheet1!V2)

On Dec 6, 5:32 pm, Ajay wrote:
I have 3 data sheets:
Sheet1, sheet2, sheet3
From Sheet1 a value V1 is taken and looked up in Sheet2 another value
corresponding to V1 ia taken say V2 (I tried doing this by Vlookup and am
able to do find V1 and take V2) and V2 is checked in Sheet3 in data which is
arranged horizontally and under this value I have a lot of values in the same
column.

I want to select this range of data and then count the number of cells for a
particular value.
How can i do it ?