Hi,
I am looking for a new and unique way to use a SumIf over multiple sheets. This is an example of what I want it to do, and what I currently have:
Let's say we have three tabs called Tab1, Tab2, and Tab3. I want the SumIf on a master page to search a column A range for a specific number and return the results from column B in that same range. The If criteria would be if Col B > 50000 Return the value or 0 if < 50000. There will be multiple rows within each worksheet which contain the values we are seeking, so it has to include the range within that worksheet. Here is what I have so far, and all it is doing is pulling the first Tab1: (Braces denote array formula)
{=SUMIF(INDIRECT("'"&A7:A9&"'!A2:A5"),G2,INDIRECT("'"&A7:A9&"'!B2:B5") )}
I am unsure where to insert my if command to have it execute through each line of the array and thus have excluded it from the string.
In this example, I am using an Indirect function to insert the sheet name (i.e. A7 = Tab1, A8= Tab2, A9=Tab3) and the SumIf range in each sheet should be A2:A5 for the reference value and B2:B5 for the Sum value. G2 is the lookup value on the master tab that I want all of the summing to be done on. Any ideas on how I can make these ranges work? My biggest gratitude for anybody that can put me on the right track!
Thanks!
Nick
Bookmarks