Daily Total Issue...

[Guest]

Hi Frank,
I've used the suggested formula earlier,
=IF(OR(AND(A2="",A3<>""),AND(B3="",B2)),SUM(INDIRECT("B" & MATCH(9.99999999999999E+307,$A$1:A2) &"B" & ROW())),"")
I got this result:
There are 2 samples below, one with a date in A4 and the other w/o.

A B C A B C
1 DATE TOM 1 DATE TOM
2 6-Jun 10 2 6-Jun 10
3 10 20 3 10 20
4 8-Jun 4
5 5 20
6TOTAL 20 6 TOTAL 40

 

[Frank Kabel]

Hi
if you manually place the word Total in the last line try the following
small change:
=IF(OR(AND(A2="",A3<>""),AND(B3="",B2<>"")),SUM(INDIRECT("B" &
MATCH(9.99999999999999E+307,$A$1:A2) &"B" & ROW())),"")


Problem is I don't know what kind of formula you have placed in the
'total' row

 

[Guest]

Hi Frank
C6 =sum(c2:c5)

 

[Frank Kabel]

Hi
then try the slightly changed formula

 

[Guest]

The benefit in joining this discussion is the fun in understanding the question figuring out the exact problem and the joy of finding the right solution to the problem.
I think you got both the fun and the joy, of course, not without much pain, headache!!

Thanks