S
Sam
I have a workbook that has several worksheets. One worksheet will be a
summary of the data on the other worksheets. The other worksheets are split
by cost center. They each have data with a column for account number,
account name and amount by month.
Sample data (same format for each cost center tab)
Account Description Jan Feb Mar Apr May Jun
1234 Salaries 124 333 432 876 987 78
5678 Travel 85 99 100 43 57 65
Summary worksheet - format
(Data in Summary tab should be for one month only)
Account Description Cost Center #1 Cost Center #2 Cost Center #3
1234 Salaries ? ?
?
5678 Travel ? ?
?
I know how to write a formula that will look at account and description and
put in the amount.
My Question is this: How do I write a formula that will look at the
account, description and then know to take the data from a specific month.
For example: It is April, so I want to pull only the April data into the
summary tab for each cost center. I am looking for a formula for the ? marks
above.
Thanks.
summary of the data on the other worksheets. The other worksheets are split
by cost center. They each have data with a column for account number,
account name and amount by month.
Sample data (same format for each cost center tab)
Account Description Jan Feb Mar Apr May Jun
1234 Salaries 124 333 432 876 987 78
5678 Travel 85 99 100 43 57 65
Summary worksheet - format
(Data in Summary tab should be for one month only)
Account Description Cost Center #1 Cost Center #2 Cost Center #3
1234 Salaries ? ?
?
5678 Travel ? ?
?
I know how to write a formula that will look at account and description and
put in the amount.
My Question is this: How do I write a formula that will look at the
account, description and then know to take the data from a specific month.
For example: It is April, so I want to pull only the April data into the
summary tab for each cost center. I am looking for a formula for the ? marks
above.
Thanks.