circular reference??

[stevie73]

hi i have the following formula in cell f4 on a sheet

=B10-F5-F6-F7-F8-F9-F10-F11-F12-F13-F14-F15-F16-F17-F18-F19-F20-F21-F22-F23-F24-F25-H4-H5-H6-H7-H8-H9-H10-H11-H12-H13-H14-H15-H16-H17-H18-H19-H20-H21-H22-H23-H24-H25

which i thought i could shorten to something like:
=B10-(F4:F25)-(H4:H25)

but its throwing an error - any help appreciated. the cells are time values

 

[Fluff]

How about
=b10-sum(f5:f25,h4:h25)

 

[KRice]

Try changing the F4 to F5

 

[stevie73]

hi yes i tried changing to f5 also so that f4 wasnt referenced but it then came up with value# error?? cheers

 

[Fluff]

See post#2, not sure if you have seen the edited version.

 

[stevie73]

hi Fluff - thank you i think that may be it - i didnt think i could use sum like that - brilliant thanks

 

[Fluff]

Glad we could help & thanks for the feedback.