Need MSExcel 2007 Formula

Closed
ishfaq90
Posts
12
Registration date
Wednesday July 17, 2013
Status
Member
Last seen
January 28, 2015
- Dec 30, 2014 at 07:53 AM
vcoolio
Posts
1352
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
July 19, 2022
- Dec 31, 2014 at 03:46 AM
Hello, Masters of Excel.
I need formula like H5+I5+J5+K5+L5+M5+N5-O5=P5. I need H5 to N5 add & subrtact O5 in P5. Hope i have detailed this brief.
Thanking in anticipation.

1 reply

vcoolio
Posts
1352
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
July 19, 2022
250
Dec 30, 2014 at 09:01 AM
Hello Ishfaq90,

Perhaps this may do the job for you:-

=SUM(H5:N5)-O5

Enter the formula in cell P5.

Regards,
vcoolio.
0
ishfaq90
Posts
12
Registration date
Wednesday July 17, 2013
Status
Member
Last seen
January 28, 2015

Dec 30, 2014 at 09:56 AM
Thanx bro. Now need another, hope u could help. In column R5 i put =IMSUM(P5,Q5).I need the amount of R5 to auto enter in S5 not formula & then i need S5+R6 in S6. This will be in spreadsheet, i am trying to making a template.
Thanks in anticipation.
0
vcoolio
Posts
1352
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
July 19, 2022
250 > ishfaq90
Posts
12
Registration date
Wednesday July 17, 2013
Status
Member
Last seen
January 28, 2015

Dec 31, 2014 at 03:46 AM
Hello Ishfaq90,

Glad I could help.

Now, for your next query:-

If I have understood you correctly, then in cell S5, enter:-

=R5

and in cell S6 enter:-

=SUM(S5+R6)

I would be interested to know why you are using the IMSUM function. Are you adding complex numbers from P5 & Q5 in R5?

If so, I would like that other forum Contributors join this thread as complex number functions such as IMSUM (addition) or IMSUB (subtraction) don't come up that often on forums and for me it is still a very grey area (actually, it has been a grey area for me since High School!!!).

Kind regards,
vcoolio.
0