Forum Discussion
XiXi
Nov 13, 2024Copper Contributor
SUMIFS Problem
Hi, Given 2 tables, table 1 (T1) in Sheet1 and table 2 (T2) in Sheet2: In T1 column C, I want to sum up numeric data from T2 column C based on two criteria. 1) The text in T2 column B matches the ...
- Nov 13, 2024
Not sure but I believe you should try
"<="&A2
Riny_van_Eekelen
Nov 13, 2024Platinum Contributor
Not sure but I believe you should try
"<="&A2
XiXi
Nov 13, 2024Copper Contributor
Perfect! Thanks 🙏
I thought & was concatenation. Why does this work? I'm no expert in excel (•⁔•)