What Bernie was communicating is that justification or alignment isn't a

uniform attribute, certainly not something on which you should rely. Text

can be left or right aligned by formatting, or by padding with spaces. Ditto

for numbers.

Is there something a little more uniform or reliable that denotes the cells

to count or to ignore?

"Laura" wrote:

> Maybe I wasn't clear . . . I don't need to sum the total of the cells I need

> to know how many cells are right-justified in each row. I hope that is a

> clearer explanation of what I am looking for.

> --

> Thank you for your assistance.

>

> Laura

>

>

> "Bernie Deitrick" wrote:

>

> > Laura,

> >

> > Justification doesn't change the underlying cell value, so it can be misleading. If you enter a

> > number, the default justification is right: enter that smae number with a leading single quote (to

> > enter it as a string) and the default justification is left. But you can change either

> > justification using formatting.

> >

> > For normally entered values in non-formatted cells, if you use a formula like

> >

> > =A1+A2

> >

> > and you will get the sum of the values, whether they are strings or not, as opposed to

> >

> > =SUM(A1:A2)

> >

> > which will only sum up true numbers.

> >

> > To count the number of true numbers in a row, you can use (to count the numbers in row 1):

> >

> > =SUMPRODUCT(ISNUMBER(1:1)*1)

> >

> > Your boss needs to do a better job of designing his spreadsheet.

> >

> > HTH,

> > Bernie

> > MS Excel MVP

> >

> >

> > "Laura" <lragsdale@geo-logic.com> wrote in message

> > news:AA5BB120-71C3-461E-BA96-40830D76FD1D@microsoft.com...

> > >I am working on a spreadsheet and the project manager needs me to write a

> > > formula to count right-justified cells in each row (so he will know if the

> > > information is going to be used for his calculations). I was told that Excel

> > > doesn't have anything built in to do this, but can it be done. If so, how????

> > > --

> > > Thank you for your assistance.

> > >

> > > Laura

> >

> >

> >

## Bookmarks