Check out this link...

http://www.xldynamic.com/source/xld.SUMPRODUCT.html
--
HTH...

Jim Thomlinson


"Welshr2" wrote:

I have 11 columns of data and would normally use sumif to add up the values
based on the doc type added, however now the VAT rate has changed I need to
identify 2 critera in 2 columns and sumif wont allow that.

Any help would be greatfully accepted