Hi,
Please see below an example of what I am trying to solve:
I'm trying to return the sum of all numbers in columns C, D & E but only where column B is "Ongoing". As you can see, the answer should be 2165 but using the following formula only gives the result of 560:
=SUMIF(B:B, "Ongoing"...