Aug 08 2022 04:14 PM
I have an exported data set that I'm trying to extract certain information from - looking for this criteria:
In this dataset, if I filter for these three items (some columns hidden), I get ONE available response on line 736 of data (sheet name - PS_excelFile) fulfilling the 3 requirements, shown here:
I am trying to replicate this exact filter extraction on a report page (below) with COUNTIFS, using this formula in cell E14 to find the three criteria: =COUNTIFS(PS_excelFile!$P$6:$P$10006,Sheet1!$A14,PS_excelFile!$R$6:$R$10006,"="&E$1,PS_excelFile!$C$6:$C$10006,"*"&$A$4&"*")
As you can see, this formula in E14 returns zero. More puzzling, pasting the formula works another person on the report page for March.
Obviously I can't trust the count right now. I have also tried using DATE in the formula to match the month, rather than comparing the date string to the header (dates usually being that which wrecks havoc with logic). Anyone see what it is that am I missing?
Thanks
Sirrobocop
Aug 08 2022 05:04 PM
SolutionAug 09 2022 06:33 AM
I believe you are on to the problem. I actually only care about the month, and tried to set it up so that it only registers the first day of the month. However, the database doesn't have that limitation. I'll implement your range check and if it doesn't work, I'll post another update. Thanks@mtarler !
sirrobocop
Aug 08 2022 05:04 PM
Solution