Forum Discussion
Using INDEX with SUMIFS?
OliverScheurich I have attached an example from my code sheet w corresponding code values and an example of how these codes appear in the other sheet, "2022" Each row in the "2022" sheet is an instance of a health inspection at a restaurant, and the codes appear each time a violation takes place within said inspection. I need to add up the point values of code violations in each row/inspection. Additionally, do I need to remove the descriptions with the codes? Just now thought about the fact that I might need to
=SUM(IF(A2:I2='Code Sheet'!$A$2:$A$9,'Code Sheet'!$B$2:$B$9))
Yes i'd remove the descriptions in the "2022" sheet because it simplifies the calculation.
OliverScheurich Apologies for the late response to your reply. I have used your formula, but all I get as an output is "0". I have attached a snip of the issue. Any ideas? Thanks again for your help with this.
Which version of Excel do you use? If you don't work with Office 365 or Excel for the web or Excel 2021 you have to enter the formula as an arrayformula with ctrl+shift+enter.
Here is an explanation about arrayformulas and ctrl+shift+enter.
OliverScheurich I believe that my company uses Microsoft Office Professional Plus 2019