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
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
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!
Yep. Change Actuals C6 to:
=DATE(Start4,COLUMNS($A:A),1)
and drag across.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Thanks for the reply. When I put that formula in C6 I get value errors.
I don't....
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?
Sorry I didn't see the attachment. Thank you very much Glenn for the help.
You're welcome.
If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.
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.
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
Last edited by CARACALLA; 12-15-2019 at 09:09 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks