I have a lists of amounts, with dates, with two different names.
For example:
A B C
Doug $100 6/3
Doug $300 5/3
Larry $200 6/1
Larry $100 5/4
Doug $400 5/3
Larry $40 6/7
So...I know =sumif(a1:a6,"Doug",c1:c6) That is how much Doug makes. $800
I want to know how much each person totals in each month.
BUT...If column A=Doug and column c is < or = 5/31 what is the total of column B? Meaning Doug made $700 is May....then I want to know what he made in June....which would be $100
How the heck do I do that?
Bookmarks