Hey all,
I'm new to this site and this is my first post, but I cant figure out what code to use for the following problem:
I have a sheet with the following 5 columns:
Acct #, Month, Year, Type A or B, and $ Amount.
Basically, what I want to do is sum up the $ amounts for Type A and B (separately), but only if it the account number is 280, the month is last month, and the year is the current year. I then want to paste this on another sheet.
I've looked through a bunch of threads and I can't seem to find anything. Help would be greatly appreciated.
Thanks!
I'm new to this site and this is my first post, but I cant figure out what code to use for the following problem:
I have a sheet with the following 5 columns:
Acct #, Month, Year, Type A or B, and $ Amount.
Basically, what I want to do is sum up the $ amounts for Type A and B (separately), but only if it the account number is 280, the month is last month, and the year is the current year. I then want to paste this on another sheet.
I've looked through a bunch of threads and I can't seem to find anything. Help would be greatly appreciated.
Thanks!