so the formula, =COUNTIFS(Apr!$D2:$D200,"Car Ins",Apr!$H2:$H200,"sale") doesn't show a little ' in front of it does it? That will stop it from working.
Otherwise you may have to post a small sample sheet that contains it to get better help.