I need help creating a formula

[Anna]

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?

 

[JE McGimpsey]

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

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

 

[Anna]

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?