Spot #VALUE! error in my formula=SUMIFS($Q$4:$Q1547,$H$4:$H1547,"*LIM*",$J$4:$J1544, "BU")

[Harrywatson]

My formula is:

=SUMIFS($Q$4:Q1547,$H$4:$H1547,"*LIM*",$J$4:$J1544,"BU")

This returns a #value! error in the cell

I am trying to add up only the values in column Q under two criteria,~~~where there is LIM somewhere down column H~~~and also BU written somewhere down column J, Please ask questions If not understood, help would be greatly appreciated.

Thankyou

 

[Weazel]

try adjusting the BU criteria range

=SUMIFS($Q$4:Q1547,$H$4:$H1547,"*LIM*",$J$4:$J1547,"BU")

 

[Harrywatson]

This shouldn't create a value error should it though? I'll try it soon thanks

 

[Jonmo1]

Yes it will.

In the ifS version of Count/Sum/Average
The ranges must be of equal dimension to each other. Same # of rows and columns.

 

[Harrywatson]

Yes it will.


In the ifS version of Count/Sum/Average
The ranges must be of equal dimension to each other. Same # of rows and columns.

Thanks so much both of you, that's so helpful, I didn't realise! Thanks a lot