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 *