Hi Guys,

Here is my problem, I'll try to be as brief and clear as possible

Basically I have a formula for Cells on page 2 : =SUMIFS(SLING;type;C10)

SLING refers to page 1 AC:14:AC10000

I won't mention the others because they don't matter they won't change


I'm tryin to add the same formula to a cell next to the first one, it would be basically the same as the other formula but i would modify SLING for EXTRA1 where EXTRA1 refers to AD14:AD10000
EX =SUMIFS(EXTRA1;type;C10)

my problem is when i do that the first formula (SLING) works perfectly BUT the new one (EXTRA1) does not work at all, (It shows value) although I look in the formula builder wich cells it is refering to and the cells are correctly showed.

I look in the cells format to make sure everything was NUMBERS and nothing was text only or date only or whatever

I also tried to modify the EXTRA1 to PAGE1!AC14:AC10000 but no improvement

If anyone could help it would be greatly appreciated !

Thanks !!