Hi, I need to calculate how many times 2 specific characters appear in the same cell throughout an entire spreadsheet of about 98 columns and 98 rows, but I can't seem to find the right formula to do this. The characters would look like "+2" and "-4" for instance, and I need to find out the amount of those characters appear in the same cell together. If someone knows how to create a formula for this I would greatly appreciate some assistance. Thanks :)

Hi, Do you have the 2 characters you are looking for in cell on the spreadsheet. For example does cell A1 contain -4

and then you want a count of the number of times -4 occurs embedded in the text of all the other cells (in the 98 columns etc.)Regards

From your post I gather you are only interested in cells with either a positive number (the plus sign)

or a negative number (the minus sign),

the numbers themselves are not important.This would lead me to believe that your cells are formatted as TEXT, if so then try something like this:

=COUNTIF(A1:D40,"-*")+COUNTIF(A1:D40,"+*")

MIKE

Thanks for responding guys! But I'm now realizing that this might work out better if I just count the cells manually, as strange as it sounds, lol. Thanks again for your help!

Ask Your Question

Weekly Poll

Do you think Google should sell budget phones in the US?

Discuss in The Lounge

Poll History