Excel SUM doesn't add display values from formula?

  Mart 18:35 26 May 05
Locked

I'm using Windows XP Pro and Office XP/Excel.
I'm trying to work on a timetabling scenario and but also want to keep a track of the total time (in minutes) allocated to each person.

I've used the following formula to try and link the cells showing when they're on or off to another set of cells relating to the time in minutes:-

=IF(C5=0,"0","90")
i.e. if the C5 cell shows them not working then 0 minutes are returned and if C5 shows them on duty for 90 minutes, then "90" is displayed.

However, when I try to use the SUM formula on these cells which display either 0 or 90 mins
it returns a value of 0. Is there a way around this problem so that the SUM function adds up the displayed figures? At the moment it appears to see only a conditional formula and is therefore ignoring it in the SUM calculation
Any help greatly appreciated!

  VoG II 18:39 26 May 05

=IF(C5=0,0,90)

(your formula gave text values which result in 0 if you sum them).

  Mart 18:56 26 May 05

So how can I alter the formula to avoid this?
What do I need to do to make it work? I'm afraid I'm still a bit of a novice

  VoG II 18:58 26 May 05

=IF(C5=0,0,90)

As above. Remove the " marks.

  Mart 19:07 26 May 05

Ah, of course. Thanks VoG™ -very much appreciated!
Mart

This thread is now locked and can not be replied to.

Intel Coffee Lake 8th-gen Core processors release date rumours

1995-2015: How technology has changed the world in 20 years

Framestore’s haunting post-WWII title sequence for new BBC series SS-GB

Best iPhone games 2017 | Best iPad games 2017: 162 fantastic iOS games that you need to play right…