How to sum by date and type in Excel 2010
We have a peculiar need where we haven't seemed it anywhere else. We need to totalize by Date and Type (see excel attached). We have placed the calculation individually by DATE and by TYPE. At the top of the excel is what we want (we sum it manually so EE can see what we want), by both DATE and TYPE.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Ok will try.
ASKER
Worked Perfectly!
Can you explain the formulas for us to better understand?
Can you explain the formulas for us to better understand?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanx a lot!
ASKER
Thanx!
ASKER
AmtByDates-Type.xls