EXCEL FORMULA ISSUE (OFFICE 2013)

  recurve132 13:58 20 Feb 2016
Locked

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 2016

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:

=SUMIF(B1:B20"0",A1:A20)

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 2016

Thanks for the answer,

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

Elsewhere on IDG sites

Best phone camera 2017

Stunning new film posters by Hattie Stewart, Joe Cruz & more

iPad Pro 10.5in (2017) review

Comment faire une capture d’écran sur un Mac ?