MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Sumif formula


Posted by Lars on January 15, 2002 4:49 PM

How do I create a range across multiple tabs for the sum if function to work?

I have tried

sumif(sheet2!a2:a15&sheet3!a2:a30,sheet1!a2,sheet2!c2:c15&sheet3!c2:c30)

The & doesn't work what do I use?

Thanks


Posted by IML on January 15, 2002 5:55 PM

Not pretty, but

Try
=SUMIF(Sheet2!A2:A15,Sheet1!A2,Sheet2!C2:C15)+SUMIF(Sheet3!A2:A30,Sheet1!A2,Sheet3!C2:C30)