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...
Rather than concatenating columns A and C (I have called them 'type' and 'code' in the absence of any other naming) I would suggest separating your criterion into two parts. This will allow the 'type' and 'code' columns to be used as criteria ranges in a SUMIFS formula.
= LET(
typeCriterion, TEXTBEFORE(criterion, " "),
codeCriterion, TEXTAFTER(criterion, " "),
SUMIFS(values, type, typeCriterion, code, codeCriterion)
)
I'm sorry, but I don't quite understand what you are suggesting that I do. Perhaps if you showed me in the actual excel file, it would be easier to understand.
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
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