Status bar showing sum and count

[Madiya]

I have to do lot ofselection and check sum and count.
Status bar in excel shows sum and count one at a time.
Is there a way, status bar shows sum and count both?

Regards,
Madiya

 

[Boris]

I have to do lot ofselection and check sum and count.
Status bar in excel shows sum and count one at a time.
Is there a way, status bar shows sum and count both?

Regards,
Madiya

Madiya,

You can try something like this (put the procedure in your worksheet's
code):
---
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
Application.StatusBar = "Sum=" & _
Str(Application.WorksheetFunction.Sum(Target)) & _
"; Count=" & _
Str(Application.WorksheetFunction.Count(Target))
End Sub

 

[Nigel]

In the customize status bar prior to xl2007 is limited unless you run some
of your own code. Xl2007 offers a lot more options.

 

[Madiya]

In the customize status bar prior to xl2007 is limited unless you run some
of your own code.  Xl2007 offers a lot more options.

--

Regards,
Nigel
(e-mail address removed)







- Show quoted text -

Thanks to both of you for help.
Boris,
However, I have a small problem.
The sheet I am working on is a dump from the SAP.
Due to this most of the cells are formatted as text.
The code you posted workes fine in general but if I select those text
formatted
cells, it shows count also = 0 instead of showing the count of cells
having anything like text.

Any fix for that?

Thanks,
Madiya

 

[Gary Keramidas]

what i do is copy a blank cell. then select the cells formatted as text, right
click, select pastespecial then add. it will change them to numbers.



--


Gary

In the customize status bar prior to xl2007 is limited unless you run some
of your own code. Xl2007 offers a lot more options.

--

Regards,
Nigel
(e-mail address removed)







- Show quoted text -

Thanks to both of you for help.
Boris,
However, I have a small problem.
The sheet I am working on is a dump from the SAP.
Due to this most of the cells are formatted as text.
The code you posted workes fine in general but if I select those text
formatted
cells, it shows count also = 0 instead of showing the count of cells
having anything like text.

Any fix for that?

Thanks,
Madiya

 

[Peter T]

In the customize status bar prior to xl2007 is limited unless you run some
of your own code. Xl2007 offers a lot more options.

--

Regards,
Nigel
(e-mail address removed)







- Show quoted text -

Thanks to both of you for help.
Boris,
However, I have a small problem.
The sheet I am working on is a dump from the SAP.
Due to this most of the cells are formatted as text.
The code you posted workes fine in general but if I select those text
formatted
cells, it shows count also = 0 instead of showing the count of cells
having anything like text.

Any fix for that?

Thanks,
Madiya


----------------------

Change Count to CountA

Regards,
Peter T

 

[Madiya]

Thanks to both of you for help.
Boris,
However, I have a small problem.
The sheet I am working on is a dump from the SAP.
Due to this most of the cells are formatted as text.
The code you posted workes fine in general but if I select those text
formatted
cells, it shows count also = 0 instead of showing the count of cells
having anything like text.

Any fix for that?

Thanks,
Madiya

----------------------

Change Count to CountA

Regards,
Peter T- Hide quoted text -

- Show quoted text -

Oh ..... so simple.
Thanks.
Madiya