Hi everyone,

Having trouble with a formula. In my spreadsheet, data spits out from a query where a project name (Column A) is merged between 3 rows. For example, row 4/5/6 are the project name. Column B has 3 rows in this order, "Base", "Override","Working". My issue is when doing a sumifs, its totaling 0, which I'm guessing is because of column A. Looking at the formula below, any idea how i might get this to work?


=SUMIFS('CF2 MP'!$N$4:$N$27000,'CF2 MP'!$B$4:$B$27000,"Working",'CF2 MP'!$A$4:$A$27000,"*SFL*")
Row N is the value I want summed when column A contains the letters "SFL" and column B is equal to "Working".

Any suggestions would be greatly appreciated.