I am trying to calculate a specific persons total numbers across four columns in the Sheet Summary. Below is the formula that I have, but it keeps returning #Incorrect Argument Set. Please…what am I doing wrong. :)
=SUMIFS([Motion Permanent Total]:[Motion Permanent Total], [Motion Temporary Total]:[Motion Temporary Total], [Still Permanent Total]:[Still Permanent Total], [Still Temporary Total]:[Still Temporary Total], >0, [Media Manager]:[Media Manager], "David Creamer _DVIRC")