How does the formula know what criteria you want in each case?
Dave.

"Setts" wrote:

How do I use SUMIF or another function to add a column of figures based on
criteria in two adjacent columns? The criteria can be either true or false.
For example, in one instance I might want to add figures based on a match in
a Column A and B and in another instance based on a match in Column A but not
B. I am using Excel 2003.