CREATE MTD AND YTD

I would like the MTD and YTD formula based on the DEPCOMB column and CATEGORY column. See the attached Excel file.

So you will have this each month in a summary like below
:
Depcomb Category Mtd Ytd

Thanks

Solution: CREATE MTD AND YTD

Something like this...You can select the month from the TOP and accordingly you can play arround as per whatever you want to do with it...

HTH...

Saurabh....

testing-experts-1-.xls (266 KB) (File Type Details)

Data....

Active

Search all fields in MS access table	Migrating Gmail contacts and calendar to exchange
while initializing device VKD-windows protection error- restart- computer shuts down	Problem: Active Directory Domain removal
Raise 2GB limit in Exchange 2007	Add radio buttons to word document
Problem: Restore deleted user account on Windows 2003 Small Business Server	error opening installation log file vista
Access form layout tips	Error message whilst trying to move mailbox from Exchange 2003 to 2007
Problem: how to delete highlighted colored rows?	Fixing - Cannot perform an aggregate function on an expression containing an aggregate
how to change Access 2003 runtime dictionary language "French"	Outlook 2007 keeps asking for password - pop3
Problem: active directory forest trust setup problem?	Problem: Cannot remove inherited permissions in Exchange
Problem: can you upgrade from server 200 to 2003?	Problem: What IIS security hole allows mIRC trojans?
Child domain users and Parent domain Exchange	Problem: No duplicate item in combobox item