The only way you can get a value error is if you calculate something seen as
text and if C1:C5 are all numbers then you can not get an error, if any
value in A1:A5 or B1:B5 are text then you can get a value error in C1:C5 and
if you get one there then the sum will return the error as well, what
happens if you use
=SUMIF(C1:C5,"<#VALUE!")
--
Regards,
Peo Sjoblom
Northwest Excel Solutions
www.nwexcelsolutions.com
(remove ^^ from email address)
Portland, Oregon
"Andrew" wrote in message
...
That's correct
"Peo Sjoblom" wrote:
Are you saying that if you use
=SUM(C1:C5)
you'll get a value error?
--
Regards,
Peo Sjoblom
Northwest Excel Solutions
www.nwexcelsolutions.com
(remove ^^ from email address)
Portland, Oregon
"Andrew" wrote in message
...
I know that, but t does not work
a b c
1 7:30 17:30 10.00
2 7:30 17:30 10.00
3 7:30 10:30 3.00
4 7:15 17:30 10.25
5 7:15 17:30 10.25
#VALUE!
Formula for c3 is =(b1-a1)*24
hope ths helps
"Peo Sjoblom" wrote:
Just use =SUM(C1:C?)
where C? is the last cell with data that you want to include
--
Regards,
Peo Sjoblom
Northwest Excel Solutions
www.nwexcelsolutions.com
(remove ^^ from email address)
Portland, Oregon
"Andrew" wrote in message
...
I need each row to have its own total, and then have a total at the
bottem
of
each column.
"Peo Sjoblom" wrote:
Maybe Andrew meant something like this in C2 so the values
accumulate
=(B2-A2)*24+C1
and copy down
--
Regards,
Peo Sjoblom
Northwest Excel Solutions
www.nwexcelsolutions.com
(remove ^^ from email address)
Portland, Oregon
"Bob Phillips" wrote in message
...
As they are just decimal numbers now, they should simply add up.
What
is
the
problem you get, give an example?
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"Andrew" wrote in message
...
I'm not sure what you mean, sorry...
"Gary''s Student" wrote:
Try formatting the sum as;
[h]:mm
--
Gary's Student
"Andrew" wrote:
I have created a formula for calculating total hours / day
the times are entered in military time
a1 = 7:30, b1 = 15:30, c1= =(b1-a1)*24, and it works great,
however I
can
not get those numbers in the C colum to add up for a rolling
total
HELP !!!!!