Forum Discussion
Solved
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 ...
Not sure but I believe you should try
"<="&A2
"Why it works?" That a good question. The on-line documentation doesn't mention it but it does mention that you could enter the criteria as a cell reference, a number or a text. The latter must to be used if you want to include <=> signs in a criterion and a cell reference. In your example you could use A2 if you want an exact match of the date in A2. But now you want <= Oct 1, 2019.
You could use "<=10/1/19", but that's not dynamic. Using "<="&A2 will concatenate into "<=10/1/19" and therefor it works.
Thanks, I’ll keep that in mind!
