I am new to excel and self-taught and am using it to make my job tremendously easier at work.
I would like to be able to write a formula that will filter and count the data from multiple columns. For instance, I would like the spreadsheet to automatically count the number of a certain code (column B) for a routing number (Column A), during a given range of dates (Column C). This spreadsheet will be updated daily with new information that is copy and pasted into it. I would like it to adjust as the information is copied into it.
I have tried looking into other forums but can't seem to make it work for my specific spreadsheet.
Thank ya kindly for any help!
Bookmarks