Sum until hit blank
perfect, once again thank you ...
so now i had to put a lot of zeros in if there was no units so it woudn't
consider it a blank and stop the formula like this example
Total 450
Style A 100
Style B
Style C 150
had to change to this:
Total 450
Style A 100
Style B 0
Style C 150
so is there a way to format all zeros as "---"?
"Teethless mama" wrote:
=SUMPRODUCT(OFFSET(B2,,,MATCH(TRUE,B2:B1000="",)))
"Tami" wrote:
hi.
I need a formula that automatically sums down to the first blank cell.
In the data below i need a formula for the Total lines below...sometimes
there are 3 styles , sometimes 2 styles, sometimes 1 style. But i don't want
to have the user to have to adjust he formula every time as it will add risk
for human error.
any suggestions?
Total 450
Style A 100
Style B
Style C 150
Total 200
Style D 150
Style E 50
Total 250
Style F 250
|