Hi all
I am a newbie to ms excel, is there any formula which can tally and divide a number horizontally in such a way that sum of those values in 'x' axis tally a certain number while sum of those values in 'Y' axis (vertically) tally another number which is manually fed in a certain cell. I have explained the problem in the attached excel sheet. Please help.
Bookmarks