I am trying to get a multiple if formula to work.
I need to look in A:A for all cells that =Y
Then in those cells look in B:B for all cells that =2
then in those cells look in C:C for cells that =21
And for the ones that match all 3 criteria sum the cells in D:D
Any help appreciated
I need to look in A:A for all cells that =Y
Then in those cells look in B:B for all cells that =2
then in those cells look in C:C for cells that =21
And for the ones that match all 3 criteria sum the cells in D:D
Any help appreciated