Hi everyone,

I am somewhat of an Excel Novice.

I thought this would be easy enough, by just nesting AND into the SUMIF, but no matter how many times I try to nest various combinations of formulas with IF and VLOOKUP and/or various other failed attempts, I believe my syntax and quite possibly my approach is incorrect. I won't post my attempts here, as they are probably quite embarrassing.

Please help, I would greatly appreciate it. This is only my 2nd day with Excel 2003.

Thanks in advance,

Nick

I am somewhat of an Excel Novice.

**My goal is to use the SUMIF formula, but expand it to use two 'range' and 'criteria' within it's parameters to SUM just one adjacent 'sum_range'.**I thought this would be easy enough, by just nesting AND into the SUMIF, but no matter how many times I try to nest various combinations of formulas with IF and VLOOKUP and/or various other failed attempts, I believe my syntax and quite possibly my approach is incorrect. I won't post my attempts here, as they are probably quite embarrassing.

Please help, I would greatly appreciate it. This is only my 2nd day with Excel 2003.

Thanks in advance,

Nick

## Comment