hello all,
i am in the process of buidling an excel spreadsheet to be used by a few people in a shared drive. i have managed to get a forumla to work for the majority of users (who all use Excel 2007) however there are a couple who are still using Excel 2003. does anyone have any ideas on how i would adapt the formula to work exactly the same. please.
The current formula is:
=SUM(COUNTIFS($H$125:$H$611,"=31/03/2014",$G$125:$G$611,{"Dog","Cat","Rabbit","Penguin","Monkey","Meerkat"}))
Basically there is a table over columns G and H which the user enters the details. they enter the date in column H and select an animal from a drop down box in column G, cells 125:600 on both. If a certain date is entered (in this case 31/03/204) and either of the animals are selected from the box then a '1' appears in the cell where the formula is entered.
Does anyone have any ideas or a formula i would be able to copy across is order to get it to work how i want it too.
Thanks guys!!
Bookmarks