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

iMac Pro review

Illustrator Charles Williams on how to create magazines and book covers

iMac Pro review

Les meilleures prises CPL (2018)