[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
111
Total visitors
111

Forum statistics

Threads
464
Messages
2,078
Members
4,401
Latest member
mubet888co
Back
Top