One way is to use the sumproduct formula:

http://www.xldynamic.com/source/xld....T.html#explain


"Clare" wrote:

How do I create a formula to SUM but SUM IF against two seperate criteria.