nest sumproduct sumif

  1. G

    Nesting SUMPRODUCT within SUMIF

    Hi guys, I need your help. I'm trying to tell excel to SUMPRODUCT 2 arrays only if the code in a colum is equal to the one specified, but nesting sumproduct within sumif doesn't seem to be working eg columns A B C x 3 2 y 2 5...

Some videos you may like

This Week's Hot Topics