Laura,

You were clear, but maybe I wasn't clear in my explanation. There are NO formulas in Excel that
depend on justification, so there is NO way that your boss's calculations can depend on
justification. The one EXCEPTION is the visual difference between numbers and text, but you cannot
determine the apparent justification of a non-formatted cell except based on the contents.

Perhaps you should post the formula that you boss thinks depends on justification.

HTH,
Bernie
MS Excel MVP


"Laura" wrote in message
...
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" wrote in message
...
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