formula to look up a date and add x, y, z columns to x, y, z row
I am taking information from sheet 1 in Excel to combine in Sheet 2
There are alot more columns the i show here but you get the idea
Date of service Repair Maintenance
Color Cut
1/1/5 10
1/3/5
30
12/1/5
40
11/1/5
90
i want to search this information and have it add up in sheet 2(november)
November Rev Collected
Repair
Main
Color 90
Cut
This will reoccur on each new sheet which will be the new month.
Please let me know if this is possible.
Thanks
Sally
|