I am using sumif to refer to another sheet.
Here is the sumif equation I am using. It is always set on Sheet2 for the sum.
'=SUMIF(Sheet2!$B$2:$B$12,B2,Sheet2!$A$2:$A$12)
I would like to be able to have this equation set on a different sheet depending on the sheet name located in the cell next to it.
'=SUMIF(C2!$B$2:$B$12,B2,C2!$A$2:$A$12) where C2 is a cell with the desired sheet name.
This doesn't work though. Any idea how I can do this? I can't use vba on this project, otherwise this would be simple.
I have attached an example that hopefully explains more clearly what I should do. Thanks a million!!
Bookmarks