If no SUMIFS matches, 1, otherwise the SUMIFS result...

Hi guys, I have a question which might not have an answer, but I'll give it a shot. Let's say I have a long SUMIFS function, one that is both processor intensive and contributes to the size of my workbook significantly. I want to test it the return value is 0, and if so return 1. Otherwise I would like to return the SUMIFS result. So I would like

Formula:

Please Login or Register  to view this content.

Without having to repeat my SUMIFS function. Anyone know a way? I feel like there's a math function hidden somewhere...

On a side, does anyone know if Excel will actually calculate those identical SUMIFS functions twice? I suppose I could test it but that would be great to know. Thanks!

Try this
=IFERROR(1/(1/(SUMIFS(... ... ... ... ... ...))),1)

Aha! Beautiful and so simple. Thanks!

Thanks for the feedback.