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
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.
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"))
