recurve132 13:58 20 Feb 16

I've a list of values in column A that are totalled at the bottom and I'd like to set a formula so that when I enter a date at side of a particular value, that value does not go forward to the total. Can anyone advise how to do this please?

  hastelloy 19:35 20 Feb 16

Assuming the date is in column B and you are using rows 1 to 20, put 0 in all B column cells and the formula in the total cell is:


This works but I'm sure there's a better way. I just can't work it out at the moment.

  recurve132 10:16 21 Feb 16

Thanks for the answer,

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

Samsung Galaxy S8 review

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

What’s happening in VR right now: From psychedelic art to combat therapy

Siri not working? Try these troubleshooting fixes