View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
y2d3 y2d3 is offline
external usenet poster
 
Posts: 2
Default 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,