N Niranjan1979 New Member Jul 14, 2023 #1 Hi, I would like to get a formula in where i need a data from other cell..Attached xls file and instruction Attachments File.xlsx 9 KB · Views: 6
Hi, I would like to get a formula in where i need a data from other cell..Attached xls file and instruction
herofox Active Member Jul 14, 2023 #2 hello,You Can Use This Formula Code: =SUMIFS($J$3:$J$8,$H$3:$H$8,$B3,$I$3:$I$8,"<>"&$C3) Attachments Sumifs.xlsx 10.2 KB · Views: 6
B bosco_yip Excel Ninja Jul 15, 2023 #3 Try, =SUMIFS(J:J,H:H,B3)-SUMIFS(J:J,H:H,B3,I:I,C3) or =SUMIFS(J:J,H:H,B3,I:I,"<>"&C3)
