problem with sumifs + indirct formula

[Gasser Soliaman]

Good day,
Dear All,
i entered a formula (=SUMIFS(INDIRECT($J$10),$B$2:$Q$2,$I13,$B$1:$Q$1,J$12) although i have seen many times in post was shared, try to do the same but not come as it is?
so i need to know what is the wrong?
thank you so much,

East​

East​

East​

East​

West​

West​

West​

West​

NORTH​

NORTH​

NORTH​

NORTH​

SOUTH​

SOUTH​

SOUTH​

SOUTH​

QTR1​

QTR2​

QTR3​

QTR4​

QTR1​

QTR2​

QTR3​

QTR4​

QTR1​

QTR2​

QTR3​

QTR4​

QTR1​

QTR2​

QTR3​

QTR4​

BISCUITS​

70​

88​

81​

81​

73​

95​

91​

83​

61​

60​

83​

75​

78​

96​

90​

89​

CHOCOLATES​

98​

69​

69​

67​

71​

59​

50​

60​

67​

94​

80​

81​

50​

85​

85​

70​

CHOCOCHIPS​

82​

76​

58​

69​

75​

84​

95​

57​

74​

69​

75​

62​

78​

52​

95​

86​

COOKIES​

53​

83​

74​

51​

60​

91​

72​

63​

66​

86​

55​

69​

65​

77​

96​

65​

NUTRI BARS​

95​

61​

53​

63​

65​

62​

73​

98​

74​

71​

56​

66​

58​

89​

96​

60​

JELLY BEANS​

73​

53​

52​

97​

94​

58​

61​

98​

53​

79​

91​

95​

83​

84​

89​

59​

BISCUITS​

East​

QTR1​

#VALUE!​

 

[Joe4]

Welcome to the Board!

For one thing, it appears that you have not structured your formula correctly.
The first argument in SUMIFS should be a range, not a string like "BISCUITS").

Why don't you explain (in English) exactly what you want your formula to do?
What exactly are you trying to sum with this formula?

 

[Gasser Soliaman]

Welcome brother,
East ,west,north,south the branches
Q1(first 3 month of the year)Q2(second three month of the year)....
Biscuits represnt the products
So simply i wanted know by this formula
Bisciuts profit inQ1 at East branch.

 

[Joe4]

Please don't make a response as the solution until your issue is resolved (that tells people that the issue has been solved, so there is no need to look at it anymore). I have unmarked it?

Is your data in an actual Table in Excel, or is it just listed? Usually, if it is an "official" table, every other row is shaded, and the headers have color fill to.
I ask because it affects how you would write the formulas.

Also, are you using any Named ranges?
If so, what are they, and what ranges are they assigned to?

 

[Gasser Soliaman]

firstly i appologize for my language

as you mention for the point of "named ranged" , this is thing i didn't expect but after i download the origninal example and make comparing, i find he named each row beside the product with name of the product ,so once i named B3:Q3 Biscuits the result successed

now it's solved thanks brother.

 

[Joe4]

OK, glad you got it figured out.
Feel free to mark it as solved now.