FORMULA QUESTION/HELP

Heather Druckenmiller

I am trying to create a formula that counts anything under 8 days in a column but by month and Fiscal year as well. Below is what I created and I get an unparseable error. Any suggestions?

=COUNTIFS({Depot Repair Collection Log Range 8}, <8, {Collection Repair Log Range 6}, "4", {Depot Repair Collection Log Range 4}, "FY2024))

jmyzk_cloudsmart_jp

@Heather Druckenmiller

If {Depot Repair Collection Log Range 8} is a text range, {Depot Repair Collection Log Range 8},VALUE(@cell)<8

If  {Collection Repair Log Range 6}, is a number range,  {Collection Repair Log Range 6}, 4

Scott Peters

Hi @Heather Druckenmiller - I notice you don't have " quote symbol on both sides of FY2024. Also, COUNTIFS is expecting all of your conditions to be true at the same time, is that your intent?