at a charity i currently volunteer for, records are kept of regular donors in excel. on one sheet we have a summary of the main list, which includes totals of money recieved, totals of all the different sources (ie, where they heard about us from), the totals of the frequencies they pay (ie, how many donate monthly, quarterly...) ... etc. on the next sheet we have the "main" list of donors, their IDs, amounts, frequency, source ...
the totals on the first sheet are updated manually, but i want to change that as there are a great number of errors.
i would like help to set up a function/formula to count the number of, for example, "Monthly" entries in the frequency column in the sheet containing the main list.
thanks for your time!