Ssronica wrote:RusselB, thank you for responding.

I tried the formula you suggested, but it added the amounts next to either X or Y, rather than telling me how many times X or Y had something in column C. Sorry if I miscommunicated!

If by "something" you mean an actual amount (i.e. not zero), RusselB's answer above should do the job.

If, on the other hand, you want any entered value (including zero and negative) counted, ISNUMBER() is your friend. See if you can use one of these:

- Code: Select all Expand viewCollapse view
`=SUMPRODUCT(ISTEXT(B3:B12);ISNUMBER(C3:C12))`

=SUMPRODUCT(B3:B12="X";ISNUMBER(C3:C12))+SUMPRODUCT(B3:B12="Y";ISNUMBER(C3:C12))

=SUMPRODUCT(NOT(ISERROR(FIND(B3:B12;"XY")));ISNUMBER(C3:C12))

The first one does not check for a valid label letter, just that there is some text there. The second one is just an elaboration on RusselB's formula, counting separately for each specified label. The third one is less rigid (accepts labels "X", "Y" and "XY") but easier to extend if you need to have value labels other than X and Y.

Pivot tables, as suggested by robleyd, are very useful and flexible, but there are a few pitfalls. Most importantly in your case perhaps: they are not "live" like formulas are. A couple of mouse clicks are required to refresh the table after entering data. (For large data tables this is a good thing, because then you don't need to wait for recalculation after each time you fill in a cell.)