Hi
I have a range of data going accross columns, the entries include, U, T, and F1 to F11.
I have a requirement to count how many of a particular type of entry there are, this needs to be done in groups, e.g, counting attendance bonuses which are included in entries, F5,F6, F8 and F11, (i.e. in one cell i need to total how many F5's,6's,8's & 11's are in that row?!). i just cant quite seem to get the formula right to count them, could anybody please help me out?!
cheers
millsy
Bookmarks