Formula

DocSpace
, ,
1

Hey i was using the following formula in Google sheets i NEED help
=COUNTIFS(‘May25’!K:K,“K”,‘May25’!H:H, “>=”&TODAY(),‘May25’!Q:Q,“<>Deduction”,‘May25’!Q:Q, “<>Pending”)

and i cant make it work in onlyoffice can you provide me with some assistance
i tried with
=COUNTIFS(‘May25’!K2:K1000,“K”,‘May25’!H2:H1000,“>=”&TODAY(),‘May25’!Q2:Q1000,“<>Deduction”,‘May25’!Q2:Q1000,“<>Pending”)

but i do not see any indication that the reference works and the formula does not work as it does in Google Sheets

Thanks in advance!

2

Hello @Lucas1234G

Without a file it is impossible to understand what data original formula references to and what result you want to get.