Can I have criteria in a SUMIFS formula compare one column of data to data in another column?

Bill Lyman

Example:

=SUMIFS([COL1]:[COL1], [COL1]:[COL1], [COL2]:[COL2] > [COL1]:[COL1])

Paul Newcome

Unfortunately not. You would need to use an additional column to make the comparison and then use this new column in your SUMIFS. It is a great idea though. Feel free to Submit a Product Enhancement Request.