Try this:

=SUMPRODUCT(--(ISNUMBER(MATCH(A2:A10,{"L","D"},0))),--(B2:B10<""))

Biff

"wester69" wrote in message
...

Hi,

I am struggling getting a formula to work and even quesitoning if I am
even using the right formula.

I want a total count my values (just number of) in column B based on IF
column A has a specific value ("L" or "D")

This formula almost works but only requires one "L" value to be present
in column A and I want it to look at each line through A2:A10

=COUNTA(IF(A2:A10="L",B2:B10))

Thanks!

-Wesley


--
wester69
------------------------------------------------------------------------
wester69's Profile: http://www.officehelp.in/member.php?userid=4689
View this thread: http://www.officehelp.in/showthread.php?t=1278723

Posted from - http://www.officehelp.in