=SUMIFS(Sheet1!D$11:D$1500,Sheet1!$A$11:$A$1500,$B19,Sheet1!$B$11:$B$1500,$A$1)
=SUMIF(Sheet1!$A$11:$A$1600,$B3,Sheet1!D$11:D$1600)
So basically is the first sumif doesnt return a result as the criteria is not met, I would like to evaluate the next sumif function - is there a way I can incorporate both functions into the one?
Thank you very much in advance
Bookmarks