Sumifs

Steven Colclough

Does anyone know how many criterion you can have with a SUMIFS? 

 

This formula works =SUMIFS([Conversion to $US]$21:[Conversion to $US]$385, [Cost Centre Description]$21:[Cost Centre Description]$385, [Cost Centre Description]6, [Fiscal Year]$21:[Fiscal Year]$385, [Fiscal Year]6)

 

But when I add one more criterion such as =SUMIFS([Conversion to $US]$21:[Conversion to $US]$385, [Cost Centre Description]$21:[Cost Centre Description]$385, [Cost Centre Description]2, Month$21:Month$385, Month8, [Fiscal Year]$21:[Fiscal Year]$385, [Fiscal Year]8, Status21:Status385, Status8) , no luck the formula wont work. 

 

Any suggestions welcome

J. Craig Williams

Steven,

 

You aren't anywhere close to the limit. I don't know what the limit might be, if there is one. but I've used at least twice as many as you have here.

 

Is there a reason why the new criteria range does not have the range as absolute?

 

Status$21:Status$385

 

like the other ranges?

Perhaps that's why it does not work.

 

Craig

Steven Colclough

Thanks Craig, works now.

J. Craig Williams

Da  nada

 

Craig