Sumif with Indirect

Hello, I am trying to bake in some indirect references to a sumif function. Currently I have information in one tab that I would like to sum in another. In "Tab A", I am trying to sum the value of column C in "Tab B" if the value of column B is greater than cell G4 in "Tab A".

The formula I am currently using is =SUMIF(INDIRECT($G$2&"!B:B"),">=$G$4",INDIRECT($G$2&"!C:C")). Cell G2 contains the name of "Tab B" and column G4 contains a date from "Tab B" that I would like to compare against. Column C contains dollar values. In my mind the evaluation of the formula is as follows:
1) Range = Tab B column B
2) Criteria = The date in column B is greater than the date in G4
3) Sum Range = Values in column C where B meets criteria in step 2

I know this is a long one so any help would be greatly appreciated!

Thanks!

When using INDIRECT with sheet references, it is always a good idea to use apostrophes around the sheet name as it is not always clear when you do and do not need them, i.e.:

INDIRECT("'"&$G$2&"'!B:B")

In your case you do need them as there is a space in TAB A.

Hope this helps.

Pete

Unfortunately neither of those worked. The formula is continuing to return zero.

Originally Posted by barrsm0

Unfortunately neither of those worked. The formula is continuing to return zero.

If you're getting 0, then the problem isn't with INDIRECT.
It's the sumif itself.

For troubleshooting sake, let's take out the INDIRECT for now.
So that leaves you with
=SUMIF('TabB'!B:B,">="&$G$4,'TabB'!C:C)

So if that returns 0, Either:
There are no values in column B that are >= G4
Or the values in column C are not really numbers.

What do each of these return
=ISNUMBER(G4)
=ISNUMBER('TabB'!B1) - And filled down to the end
=ISNUMBER('TabB'!C1) - And filled down to the end

Jonmo, your solution worked. Thanks so much!

Originally Posted by barrsm0

Jonmo, your solution worked. Thanks

I didn't offer a solution. I only suggested troubleshooting steps.

I assume those steps led you to a solution though, so You're welcome.

Care to share what the actual problem/solution was?

Sorry, let me clarify. The "criteria" was not formatted properly - it should have been ">="&$G$4. The formula was not evaluating the date in that cell properly.

Originally Posted by barrsm0

The "criteria" was not formatted properly - it should have been ">="&$G$4.

That solution was posted by Tony Valko in Post #2