# Totals By Months From Another Sheet Matching Category

1. ## Totals By Months From Another Sheet Matching Category

Hi,

Can someone see why my formulas on the Actual sheet aren't putting the totals for each category and month. I highlighted the cells on the Transactions and Actual sheets in yellow.

Thanks

2. ## Re: Totals By Months From Another Sheet Matching Category

Change the formula in C6 to

=DATE(Start4,COLUMN(A1),1)

and copy across to N6.

BTW, the fomula in B7 down has a #REF!

3. ## Re: Totals By Months From Another Sheet Matching Category

Yep. Change Actuals C6 to:

=DATE(Start4,COLUMNS(\$A:A),1)

and drag across.

4. ## Re: Totals By Months From Another Sheet Matching Category

Thanks for the reply. When I put that formula in C6 I get value errors.

I don't....

6. ## Re: Totals By Months From Another Sheet Matching Category

Thanks Glenn it does work for the formulas but now I don't have the columns showing the Month titles like January, February, etc.

Is there a way around this?

7. ## Re: Totals By Months From Another Sheet Matching Category

Sorry I didn't see the attachment. Thank you very much Glenn for the help.

8. ## Re: Totals By Months From Another Sheet Matching Category

You're welcome.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.

9. ## Re: Totals By Months From Another Sheet Matching Category

Actual

C7=SUMPRODUCT((\$A7=Transactions!\$C\$6:\$C\$17)*(Transactions!\$F\$6:\$O\$17)*(MONTH(Transactions!\$A\$6:\$A\$17)=MONTH(C\$6))*(Transactions!\$A\$6:\$A\$17<>""))

copy across and down

Monthly Analysis

C3=IF(\$A3<>"",SUMPRODUCT((Actual!\$A\$7:\$A\$36='Monthly Analysis'!\$A3)*(MONTH(Actual!\$C\$6:\$N\$6)=MONTH(\$F\$1&0))*(Actual!\$C\$7:\$N\$36)),"")

Copy down

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1