T
Tre_cool
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
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