getting confused
This is the final homework for today's functions with some of the functions that we have covered in the previous sessions Publisher Genre Date Qty Unit Sales Total Sales Nintendo Sports 22-01-2020 10 ₹ 1,37,853.00 ₹ 13,78,530.00 Nintendo Shooter 23-01-2020 12 ₹ 1,32,117.00 ₹ 15,85,404.00 Nintendo Puzzle 24-01-2021 20 ₹ 1,06,470.00 ₹ 21,29,400.00 Nintendo Shooter 25-01-2023 13 ₹ 1,36,030.00 ₹ 17,68,390.00 Berkeley Simulation 20-01-2020 16 ₹ 1,43,686.00 ₹ 22,98,976.00 Avanquest Software Racing 21-01-2021 10 ₹ 1,05,918.00 ₹ 10,59,180.00 Avanquest Software Shooter 17-01-2020 15 ₹ 1,48,762.00 ₹ 22,31,430.00 Avanquest Software Puzzle 18-01-2021 14 ₹ 1,23,919.00 ₹ 17,34,866.00 Avanquest Software Shooter 19-01-2023 15 ₹ 1,21,464.00 ₹ 18,21,960.00 Avanquest Simulation 14-01-2020 10 ₹ 1,49,433.00 ₹ 14,94,330.00 Avanquest Racing 15-01-2021 14 ₹ 1,02,671.00 ₹ 14,37,394.00 Avanquest Sports 16-01-2023 18 ₹ 1,19,780.00 ₹ 21,56,040.00 Avalon Interactive Shooter 11-01-2020 14 ₹ 1,20,131.00 ₹ 16,81,834.00 Avalon Interactive Puzzle 12-01-2021 16 ₹ 1,23,919.00 ₹ 19,82,704.00 Avalon Interactive Shooter 13-01-2023 17 ₹ 1,32,522.00 ₹ 22,52,874.00 1 If the total sum of sales for Nintendo for Genre-Shooter is greater than 2.5 lakhs then return "Target met" else return "Target not Met". Using IF and SUMPRODUCT Using IF and SUMIFS getting confused in solving this
