Hi All,
I wonder if you might be able to please help me, I am trying to create a formula to sum amounts based on the status of a persons deal (think sales pipeline for lines of business). I’m trying to Sum a series of If statements (I think!)
As you can see from this example, there are 3 types of incomes, and each person/customer might be Open or Closed under each line of business.
So what I am trying to do is Sum all income types If the status is Open (I.e. to create a Total amount for Open deals). In this example Person 1 is only income type A and Open, so the desired outcome is to produce a $1,000 result. Person 2 has income in 2 lines of business, but 1 is closed, so I want it to only sum the Open one, again $1,000. But person 3 has income from lines of business A and C, and both are Open, so I want it to have a $2,000 sum.
I have tried with If, Sum and Or statements, but I just have no idea what the logic is I’m supposed to use for what may be fairly straight forward for an experienced formula user.
Using IF({A Status}=‘Open’,{A Income}) returns just the A Income field, how can I get it to check for Open status in B and C, and then Sum all the incomes together?
Any help would be greatly appreciated!!