Home

SUM not working on values calculated using formulas

Highlighted
Kirsty_TJ1980
Occasional Visitor

I can't share a preview of the document due to the nature of it. 

 

Data in our accident sheet. 

 

Columns T & U are the sickness dates. The cell is in date format.

Column V is =NETWORKDAYS (T00, U00). The cell is in general format

I wanted to add the values in V38:V250 and put it in cell F6. 

 

In cell F6 I typed in general cell format. =SUM(V38:V250) and instead of X day of numbers it is showing -62006. When it should read 62. I tried removing the formula from the V cells and just manually typing the number in and it still doesn't read the correct figure. 

 

riddor.PNGformula.PNG

 

 

 

Related Conversations
I need the Formual...
alanaj in Excel on
1 Replies
Pivot table
gabriellerocha in Excel on
5 Replies
CHALLENGE
marcialfigueroa in Excel on
0 Replies