I need help creating a formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Anna - 02 Oct 2006 05:06 GMT

I need help in creating and linking a formula. Here my scenario:

In SpreadsheetA, I have a column of data and each cell in that column
has a value of either WA or CC. I want a formula that will give me a
TOTAL of all of the WA's and all of the CC's in that column. I want the

total number of each to be displayed in cells in SpreadsheetB. (It is
actually in another workbook).

In SpreadsheetB I have a cell created for # of WA and a cell for # of
CC from SpreadsheetA. I do NOT want to have to manually count how many
I have of each.

How can I do this with a formula?

Reply to this Message

JE McGimpsey - 02 Oct 2006 06:00 GMT

Take a look at the COUNTIF() entry in XL Help. For instance:

=COUNTIF(Sheet1!A:A,"WA")

> I need help in creating and linking a formula. Here my scenario:
>
[quoted text clipped - 10 lines]
>
> How can I do this with a formula?

Reply to this Message

Anna - 03 Oct 2006 05:01 GMT

Thanks. This does the job.

However, when I close the spreadsheet and reopen, Excel asks me if I
want to update. If I update, the cells change from the correct count in
each cell to an error message #VALUE! in each cell. So I have to click
"don't update" to keep this from happening. Why is that? Is there
something else I need to do to keep this from happening?

> Take a look at the COUNTIF() entry in XL Help. For instance:
>
[quoted text clipped - 14 lines]
> >
> > How can I do this with a formula?

Reply to this Message