Forum Discussion
Need help with a formula to sum of the values in column E and column F in every row (1 thru 11) if t
Device/OS System - Desktop PC - System Type 64bit OS x64based processor Windows 10 Pro, version 22H2, installed 7/6/2022, OS Build 19045.3803 Excel Version - Installed as Part of Microsoft 365 - en...
I wanted to provide the excel file initially, but I didn't know how. I think that this link should allow anyone with it to access the file. Please let me know if it is not accessible.
https://1drv.ms/x/s!AuLK-DgGW47_gf9Y5Dnzb64HDTfuYA?e=Stdtgh
=SUMIFS(E1:E11, A1:A11, "Check", C1:C11, "NATHCO")+SUMIFS(F1:F11, A1:A11, "Check", C1:C11, "NATHCO")
or
=SUMPRODUCT(E1:F11*(A1:A11="Check")*(C1:C11="NATHCO"))