Daily Total Issue...

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
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 :)
 
Back
Top