Best Answer:
You did not state which version of MS-Excel you are using, so I will assume 2003 or earlier (though the same basic information is valid for 2007).

Let us say that your first row contains header labels for the data that comes below on the rows from 2 on down. And that column "A" will show the list of names, while column "B" has the "x" values you have entered.

The formula below will give you the total amount of all those names that were flagged with an "x", which are assumed to be equal to $20 dollars:

• = COUNTIF( B:B, "x" ) * 20

or

• = COUNTIF( B2:B200, "x" ) * 20 . . . . . (where you specify a range of cells)

The formula below will give you a count of all names that you have entered in column "A":

• = COUNTA( A:A ) - 1 . . . . . . (the -1 is for the single header label)

or

• = COUNTA( A2:A200 ) . . . . . (where you specify a range of cells)

You can use either the COUNTA or the COUNTIF function to find out how many names were flagged with the "x" value. If you type this in by hand, then you will see a small pop-up "tip" show below your cursor position as soon as you enter the function followed by the open parenthesis. If you move your mouse over that "tip", you can click the function name to get detailed information and an example.

.

Source(s):