hi, i currently have a working forumla for excel 2007 which is =COUNTIFS($H$2:$H$4000, ">="&$P$2,$H$2:$H$4000,"<="&$P$3,$E$2:$E$4000,"=Dog") however i am trying to adapt it for someone who only has access to excel 2003. please could someone help me with this??
The cells in column E is a drop down list containing options such as 'dog' 'cat' etc.
Cell P2 contains the start date of the spreadsheet
Column H contains dates which the user enters.
The overall result only counts entries which have both Dog written in column E and a valid date entered in column H.
Please can someone help me with this??
Many thanks,
Bookmarks