I have a spread sheet with values in one column and a second column with
just "Yes" or 0 depending on if column A satisfied a criteria. I would
like to search through column B and find the sum of column A between
the "Yes" rows. For example I would like to find the sum of Column A
between line 1 and 4 and the sum between 4 and 6. It must work when the
"Yes"'s are in different lines as well.
EG.
line Col A Col B
1 3 Yes
2 6 0
3 8 0
4 11 Yes
5 12 0
6 16 Yes

Please help as I've been struggling with this for a little while.

Thanks in advance!
Trev


--
Tre_cool
------------------------------------------------------------------------
Tre_cool's Profile: http://www.excelforum.com/member.php...o&userid=26416
View this thread: http://www.excelforum.com/showthread...hreadid=396852