Forum Discussion
SUMIFS with IF and AND functionality monster
Team, the code and formulas i have typed into a few of my cells trying to figure this out has turned into a monster i have lost control of. Details are below. This spreadsheet is used to summarize o...
My first response is: why not add the two SUMIFS together and omit the <> criteria? Depending on what your summary table looks like that may not be an option.