formula needed

[Darrell]

Hello,
I hope I can explaine this well enough. I am using two worksheets
Worksheet 1 is an imported file, worksheet 2 is where all m
calculations are getting done. Sheet 1 column A and column C are th
only two columns I need to look at. Sheet 2 has the values of what I a
looking for in sheet 1. All data is also alpha characters. No numbers.

I need a formual to:

find the value from sheet 2. The value will be repeated several time
on sheet 1. When finding value, count cell in column A as long as lon
as it is not blank.

Thanks for any help you can give

 

[Biff]

Hi!

Need a better explanation!

When finding value, count cell in column A as long as long
as it is not blank.

That doesn't make sense!

Biff

 

[JulieD]

Hi Darrell

i'm going to assume you meant, count the number in column A of sheet1 as
long as the value in column C of sheet 1 is not blank
formula on Sheet2 is (where the value you're looking up is in cell A2)

=SUMPRODUCT(--(Sheet1!$A$1:$A$100=A2),--(Sheet1!$C$1:$C$100<>""))
check out http://www.xldynamic.com/source/xld.SUMPRODUCT.html
for details on the sumproduct function