Need MSExcel 2007 Formula

Closed
ishfaq90 Posts 9 Registration date Wednesday 17 July 2013 Status Member Last seen 28 January 2015 - 30 Dec 2014 à 07:53
vcoolio Posts 1411 Registration date Thursday 24 July 2014 Status Contributor Last seen 6 September 2024 - 31 Dec 2014 à 03:46
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.
Related:

1 response

vcoolio Posts 1411 Registration date Thursday 24 July 2014 Status Contributor Last seen 6 September 2024 262
30 Dec 2014 à 09:01
Hello Ishfaq90,

Perhaps this may do the job for you:-

=SUM(H5:N5)-O5

Enter the formula in cell P5.

Regards,
vcoolio.
ishfaq90 Posts 9 Registration date Wednesday 17 July 2013 Status Member Last seen 28 January 2015
30 Dec 2014 à 09:56
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.
vcoolio Posts 1411 Registration date Thursday 24 July 2014 Status Contributor Last seen 6 September 2024 262 > ishfaq90 Posts 9 Registration date Wednesday 17 July 2013 Status Member Last seen 28 January 2015
31 Dec 2014 à 03:46
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.