software

Anybody with assistance please.

I want to calculate the data in cells to provide a value for a second
calculation.

Example

Column A
Row 1 DRY061GP
Row 2 FRT234GP
Row 3 FYY233GP
Row 4 =Sum(A1:A2)

Thank you,

RudiAre you trying to count the number of times an entry, such as FRT234GP,
occurs in the list, or actually sum the values within them, as 61 234 233
might give you?

If you want to count the number of times an entry shows up, use the
COUNTIF() function, like:
Row 4 =COUNTIF(A1:A3,quot;FRT234GPquot;)
will return 1 since it only shows up once in the list.

quot;Rudiquot; wrote:

gt; Anybody with assistance please.
gt;
gt; I want to calculate the data in cells to provide a value for a second
gt; calculation.
gt;
gt; Example
gt;
gt; Column A
gt; Row 1 DRY061GP
gt; Row 2 FRT234GP
gt; Row 3 FYY233GP
gt; Row 4 =Sum(A1:A2)
gt;
gt; Thank you,
gt;
gt; Rudi
gt;

No,I want to count the cell if data is input to the cell. If data is
captured the value of the data need to be =1 for that cell. At the end of
the column the calculation need to provide a value of the amount of data as
per the example for that column.

Thanks

quot;JLathamquot; wrote:

gt; Are you trying to count the number of times an entry, such as FRT234GP,
gt; occurs in the list, or actually sum the values within them, as 61 234 233
gt; might give you?
gt;
gt; If you want to count the number of times an entry shows up, use the
gt; COUNTIF() function, like:
gt; Row 4 =COUNTIF(A1:A3,quot;FRT234GPquot;)
gt; will return 1 since it only shows up once in the list.
gt;
gt; quot;Rudiquot; wrote:
gt;
gt; gt; Anybody with assistance please.
gt; gt;
gt; gt; I want to calculate the data in cells to provide a value for a second
gt; gt; calculation.
gt; gt;
gt; gt; Example
gt; gt;
gt; gt; Column A
gt; gt; Row 1 DRY061GP
gt; gt; Row 2 FRT234GP
gt; gt; Row 3 FYY233GP
gt; gt; Row 4 =Sum(A1:A2)
gt; gt;
gt; gt; Thank you,
gt; gt;
gt; gt; Rudi
gt; gt;

Alright, then look at the COUNTA() function. It counts non-empty cells in a
range.

Col A
Row 1 DRY061GP
Row 2 FRT234GP
Row 3 FYY233GP
Row 4 =COUNTA(A1:A3) will display 3

Col A
Row 1 DRY061GP
Row 2
Row 3 FYY233GP
Row 4 =COUNTA(A1:A3) will display 2quot;Rudiquot; wrote:

gt; No,I want to count the cell if data is input to the cell. If data is
gt; captured the value of the data need to be =1 for that cell. At the end of
gt; the column the calculation need to provide a value of the amount of data as
gt; per the example for that column.
gt;
gt; Thanks
gt;
gt; quot;JLathamquot; wrote:
gt;
gt; gt; Are you trying to count the number of times an entry, such as FRT234GP,
gt; gt; occurs in the list, or actually sum the values within them, as 61 234 233
gt; gt; might give you?
gt; gt;
gt; gt; If you want to count the number of times an entry shows up, use the
gt; gt; COUNTIF() function, like:
gt; gt; Row 4 =COUNTIF(A1:A3,quot;FRT234GPquot;)
gt; gt; will return 1 since it only shows up once in the list.
gt; gt;
gt; gt; quot;Rudiquot; wrote:
gt; gt;
gt; gt; gt; Anybody with assistance please.
gt; gt; gt;
gt; gt; gt; I want to calculate the data in cells to provide a value for a second
gt; gt; gt; calculation.
gt; gt; gt;
gt; gt; gt; Example
gt; gt; gt;
gt; gt; gt; Column A
gt; gt; gt; Row 1 DRY061GP
gt; gt; gt; Row 2 FRT234GP
gt; gt; gt; Row 3 FYY233GP
gt; gt; gt; Row 4 =Sum(A1:A2)
gt; gt; gt;
gt; gt; gt; Thank you,
gt; gt; gt;
gt; gt; gt; Rudi
gt; gt; gt;