Sumif Problem

Storybox

I get a 'incorrect augment set' error with formula

=SUMIF([Int/Ext]10:[BASE VALUE $]100, "Int", [BASE VALUE $]10:[BASE VALUE $]100)

and have checked that the column 'Base Value $' is a text/Number format (having looked at previous comments). Any ideas what else to check

Mehmet Zengin

I think problem is that your range and sum range overlapping.

Below one is worked fine for me;

=SUMIF([Int/Ext]1:[Int/Ext]2, "Int", [BASE VALUE $]1:[BASE VALUE $]2)