Not sure which functions to use

[chris667]

Hello,

I need to add values from a range but I need the Sum to stop if it sees a certain value.

ie: range is from A1:A8
A1 = Dan, A2 = Bob, A2 = Chris, A3 = doug etc...

I want to add the cells (1 point for each) until the Name "doug" comes and stop counting after it does. If the name never appears then add from 1 to 8.

Thanks.

[martindwilson]

with that range and text to be looked for in B1
=IF(ISNA(MATCH(B1,A1:A8,0)),COUNTA(A1:A8),COUNTA(INDIRECT("A1:A"&MATCH(B1,A1:A8,0))))

[chris667]

Thanks alot. Took me some time to understand it but I'm much better off now. LOL.