3

Is there a way to add a function to the customized status bar in Excel 2007?

I want to include a subtract method next to functions such as SUM, COUNT, AVERAGE, etc.

  • Also, SUM, COUNT, AVERAGE, MINIMUM, and MAXIMUM are all defined when more than two cells are selected -- DIFFERENCE would not be. – Scott Sep 18 '12 at 19:26
  • Yes, I figured it was not implemented due to the cell property constraints as mentioned by @pnuts. So I will have to find an alternate solution that could increase my worksheet productivity. Thanks for the feedback. – Alex Sep 19 '12 at 13:57
0

Here's a workaround.  I took IBM's opening and closing stock prices for the month (from http://www.nasdaq.com/symbol/ibm/historical) and then duplicated the data in the negative:

            screen shot of Excel shhet with E4 = -B4, etc.

Now I can subtract any two numbers by selecting one and the negative of the other.  For example, IBM gained 57¢ in trading on 9/14:

            screen shot of same sheet with C11 and E11 (i.e., -B11) selected

  • 1
    Excellent! so the hack will involve creating a macro that can convert a column to negative value? – Alex Sep 20 '12 at 14:11
  • 1
    I've been fiddling with some of the function's in Excel and found the =IMSUB function which in contrast will just calculate the difference of two cells as long as they are real numbers. It would look like this for @Scott's example: =IMSUB(C11,B11) =>The output would be 0.57 only caveat is that would require another column in your workbook as oppose to the result appearing in the customized header. – Alex Oct 10 '12 at 19:59
0

Dick Kusleika addressed this in 2004, see here:

http://www.dailydoseofexcel.com/archives/2004/12/09/selection-stats/#comments

(look through the comments on the article too.) A drawback with this approach is that Excel's standard status messages are no longer visible.

  • Interesting discussion thread. Thank you for sharing this information with us. – Alex Sep 20 '12 at 14:29
  • And will this work for Excel 2016? – wizlog Jun 16 '16 at 21:22

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.