Hi Everyone,
I could do with some help with a COUNTIF problem I知 having. What I知 trying to do is count how many rows in tab 1 meet the following criteria.
Date in coulomb equal to or greater than date in tab 3
Date in coulomb equal to or less than date in tab 3
Type in coulomb matches type in tab 2.
The formula I知 using is below but I知 sure for some obvious reason does not work. Any ideas?
=COUNTIF(Register!$D6:$D$5005,=>'Data Graph'!$AA$12)*(Register!$D6:$D$5005,=<'Data Graph'!$AB$78)*(Register!$G6:$G$5005,=Lists!$D$3)
Thanks for any help in advance.
E
Bookmarks