COUNTIFS error as VALUE!

[krishnaa_kumarr88]

Hi,

I tried to put this formula
=COUNTIFS('Sheet1'!A24:A6842,"CHRIS", 'SHEET2'!G24:G8496, "RAY" )

That is
in my Sheet2 i would like to find how many rows having name "CHRIS" and "RAY" together.
Say example: If there are 10 rows having those two names in sheet1 then i should get 10 in sheet2.

But i am getting error as VALUE!

thanks

[HansV]

The two ranges don't have the same number of cells - that causes the problem. And shouldn't the second range be on Sheet1? Try

=COUNTIFS('Sheet1'!A24:A8496,"CHRIS",'Sheet1'!G24:G8496,"RAY")

[krishnaa_kumarr88]

GREAT. YEAH ITS WORKING

THANKS