[Solved] want to know the error i did in this excel formula

Cyril Priya

New member
MonthShopsSalesRentSalaryElectricityTotal ExpensesProfit
AprilAbs &Co1,85,000
20,000​
32,000​
5,000​
57,000​
=sum(d2:f2)/h2 in this i am not geting the output
May2,35,356
15,253​
25,458​
25,458​
2,500​
53,416​
JuneBs&Co
35,458​
5,825​
45,000​
1,500​
52,325​
JulyRani&co
85,563​
65,689​
25,000​
3,500​
94,189​
AugustLg&Co7,45,896
7,560​
45,000​
1,500​
54,060​
SeptemberCss&Co5,25,236
4,850​
50,000​
5,000​
59,850​
OctoberKk&Co4,45,869
7,850​
45,000​
6,000​
58,850​
 

Attachments

Greetings Priya,

Below, I attached a file that has the solution to the problem that you asked for. The formula that you entered is not plausible in real life and will create confusion. The corrected profit calculation is now presented in cell H2. Moreover, other cells in the worksheet is now restructured and reformatted. If still have any more questions, please don't hesitate to contact us again.
 

Attachments

Online statistics

Members online
0
Guests online
98
Total visitors
98

Forum statistics

Threads
470
Messages
2,067
Members
3,536
Latest member
hi88red3
Back
Top