Sumif criteria - text strings?

[buergerk]

How to sum values in Col B between two different text strings in Col A?
Thank you!

[FDibbins]

if you mean something like...sum between "start" and "finish", no, sumif() doesnt work that way.

as an example, would "nearly" be before "start", after "start, before "finish" or after "finish"?

you would need to somehow convert your text strings to a value for that

[buergerk]

What if I "start" and "finish" are always just that ... just the number of rows between will vary?
Thanks .....

[daddylonglegs]

You can use a formula like this

=SUM(INDEX(B:B,MATCH("Start",A:A,0)):INDEX(B:B,MATCH("Finish",A:A,0)))

[buergerk]

Got it now, thank yoy