Home

SUM not working on values calculated using formulas

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
Tabs and Dark Mode
cjc2112 in Discussions on
21 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies