Hi all,
I am using the SUMIFS formula with 5 criterias. It works fine when the fifth criteria is equal the column header (ie >25% probabilty etc) but I want the forumla to now sum the cells where no probability has been input ie the cell is blank.
So: sum column A ($ amount) when column B...