Search results

I swear this code was working - before I tweaked it! It's supposed to autofill on 3 columns, based on the last cell with a value in column A (I think). Column A is being populated with a formula, so maybe that won't work? I do have other columns with data, and could use one of those - I'm...

Thank you - I think I've managed to upload the example..............

I want to know, from a list of event attendees, who is coming to each of two seperate events. I've pivoted my data with the names of two events as column headings but I only want a total of folks coming to both events. I tried countifs and sumifs but I don't think the range is working...

That worked! Thank you for your time and genius:)

The fiscal year runs from August 1st thru July 31, beginning in 2007. I have a list of 6,000 records of gifts and I group these by fiscal year to get a total for the fiscal year. I do this on a monthly basis. So, I'm basically summarising 6,000 records. As I said, I had been filtering on...

The dates are being colored by fiscal year (there's four years worth of records). The original idea was to filter by color and sum column c to get a total for the particular fiscal year.

Following a previous post from Hui, I was able to add a module and get the formula below to work. But how can I tweak it if the formating has been applied to the date column (e.g. column A) but I need to sum the cash column (e.g. column C)? =ColorFunction($K$22,$M$1:$M$20,TRUE)