Please help with Formula

[NeoSez]

I was given this formula but it doesn't seem to count properly. It's supposed to count all the tickets for each company. Can someone see what I am missing? Thank you.

=IF($B$1="All",COUNTIFS(Tickets!$F:$F,$A3,Tickets!$B:$B,">"&TODAY()-$J$2),
IF($B$1="OPEN",COUNTIFS(Tickets!$F:$F,$A3,Tickets!$C:$C,"OPEN",Tickets!$B:$B,">"&TODAY()-$J$2)+COUNTIFS(Tickets!$F:$F,$A3,Tickets!$C:$C,"IN PROGRESS",Tickets!$B:$B,">"&TODAY()-$J$2),
COUNTIFS(Tickets!$F:$F,$A3,Tickets!$C:$C,"Closed",Tickets!$B:$B,">"&TODAY()-$J$2)))

Tickets!$F:$F = Name of Company, (which is also $A3 on current sheet)

Tickets!$B:$B = Date Ticket Opened

Tickets!$C:$C = Status (Open, In Progress, Closed)

$J$2 = Number of Days being calculated. For this purpose, we are calculating up to 365 days.

 

[Peter_SSs]

but it doesn't seem to count properly.

For the sample data I have tried (very small) it seems to count correctly.
Could you give a small set of dummy sample data (preferably with XL2BB so we can copy for testing) where it is not counting properly and explain in relation to that sample?