Excel Query

Hi, I work in Finance.

My goal is to use the formula to make the “total receieved” which contains the formula =SUM(L22:L25) to NOT take into consideration the red text, but only calculate numbers with black text.


31/01/2017 31 5,026.43
28/02/2017 28 4,540.00
31/03/2017 31 5,026.43
  PO Raised for: £14,600.00
  Total receieved: £14,592.86
  Left on PO: £7.14


Please help./

By: andrew

Leave a Reply

Your email address will not be published. Required fields are marked *