Add an Argument to this SUMIFS function
Posted on 2014-07-21
How would I modify this SUMIFS Function to subtract fields in "HisDataSUM" in which the values in column C were equal to the values in column D?
SUMIFS(HisDataSum!$A:$A,HisDataSum!$B:$B,IF(D13="All","<>0",D13),HisDataSum!$C:$C,IF(D14="All","<>0",D14),HisDataSum!$E:$E,IF(D16="All","<>0",D16) - X,
Using all the same criteria for cells D13, D14, and D16 X needs to Sum the values in HisDataSum column A only in the instances where the values in column C = column D.
If there is an easier way to do this; such as forget about the subtraction and only sum if column C <> column D that will work as well!
Thanks in advance!