Forum Discussion
zxcv
Jul 18, 2025Copper Contributor
sumifs doesnt work because of power query
Hi All, I've been trying to automate some regular reports using power query. The queries for the different reports are working and everything is fine, however I want to use those query tables and s...
SergeiBaklan
Jul 19, 2025Diamond Contributor
In addition
- what do you mean under "formula not working", it returns an error or result is not as you expected?
- If some result is returned, is it higher or lower of expected one?
If in P5 is date, not day, right part of the
SCRAP!$B:$B,"<="&DATE(YEAR(SCRAP!$B$2),MONTH(SCRAP!$B$2),P$5)
returns date in next century and condition is always TRUE if in column B are dates.
If in column B are texts which looks like dates, condition always returns FALSE since any text is "greater than" any number. Date in Excel is actually number.