I already created formula to bring the value from data source and now I am trying to calculate the Grand total for GROUP without affecting below cells values.
Looking for your assistance.
Excel file attached
I already created formula to bring the value from data source and now I am trying to calculate the Grand total for GROUP without affecting below cells values.
Looking for your assistance.
Excel file attached
Have you considered using a pivot table for this? Would be much simpler I believe.
No. This is just a sample data for few weeks. I have few extra columns on the right side, where I do the comparison with Budget and Forecast (That part I removed from the attached file to reduce the file size).
Hi abdumon
Can I ask why you are not using a pivot table?
f7=IF(D7="",SUMIFS(F$6:F6,$C$6:$C6,$C6,$E$6:$E6,""),IF(AND($D7<>"",$E7=""),SUMIFS(F$6:F6,$D$6:$D6,$D6),SUMIF(Data!$A:$A,$B7&"-"&F$3,Data!$F:$F)))
Try this and copy across
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks