Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
How to approch this kind of problem.
Not able to implement
Stock=IF(SUMIF(Data!J:J,REPORT!$A6&"NEWBHW",Data!D:D)=0,
SUMIF(Data!J:J,REPORT!$A6&"NEXBHW",Data!D:D),SUMIF(Data!J:$J,REPORT!$A6&"NEWBHW",Data!D:D))
Thanks
Hi @Anonymous ,
Kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.
User | Count |
---|---|
88 | |
74 | |
69 | |
65 | |
58 |
User | Count |
---|---|
104 | |
94 | |
76 | |
62 | |
59 |