formula to look up a date and add x, y, z columns to x, y, z row

S

Sally J

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
 
B

Barb Reinhardt

I'd use a helper column to get the month and year if necessary. Let's say
A2 has the date, in the helper column row 2, I'd enter
=month(A2)&"-"&year(A2) and copy down.

I'd then use a pivot table to get the information you need.
 
Top