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...
Without seeing your actual workbook, it's hard to be certain about this, but you appear to have spaces before "NATHCO" in column C, so that when that's concatenated with column A it comes out as
"Check NATHCO" rather than "CheckNATHCO"
Check also to make sure your numbers are in fact numbers, rather than text masquerading as numbers.
And if you can, it would be far more helpful if you posted an actual workbook/spreadsheet. If you can't do it here--and you've been around long enough you might be able to--then use OneDrive or GoogleDrive and paste a link here that grants access.
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.
=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"))
