If Statment

[romeo1mike]

I need help with a formula that would do the following: for example i
you has a list of leters in B1:B10 and a list of numbers for A1:A1
what I need to know is the fomula that would look at the letters i
B1:B10 and if they met a value that I needed then would count th
numbers in A1:A10. So, if B1:B10 = A then it would count the numbe
value for A in A1:A10. Hope that made sense, if not I will try t
clerify, thanks for the hel

 

[Frank Kabel]

Hi
try
=INDEX(A1:A10,MATCH("A",B1:B10,0))

 

[Soo Cheon Jheong]

Hi,


=INDIRECT("A"&MATCH(D1,$B$1:$B$10,0))


--
Regards,
Soo Cheon Jheong
_ _
^¢¯^
--