Forum Discussion
I've got the SUMIFS blues
I posted the same discussion a couple days ago, but don't see it on here anymore. Thought I'd try again. I'm using Microsoft 365 Apps for Business version of Excel on a PC. Background: I'm making a...
=SUMPRODUCT(IF($B$3:$N$8=$G13,$C$3:$O$8*$H13+$I13))An alternative could be this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.