sumif with two criteria on on difference worksheets
In Excel 2003 I have four columns on worksheet 1 and four columns on
worksheet 2. I want to sum column C on worksheet 1 if column A on worksheets
1 and 2 are the same three numbers (formatted as text); and the column D on
worksheet 1 equals two letters (AB, CD, EF, etc).
Thanks,
|