# Spreadsheet Formula Help!!!

Microsoft Excel 2003 (full product)
November 16, 2009 at 22:52:24
Specs: Windows XP
 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 :)

See More: Spreadsheet Formula Help!!!

#1
November 17, 2009 at 08:53:29
 Hi,Do you have the 2 characters you are looking for in cell on the spreadsheet. For example does cell A1 contain -4and 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

Report •

#2
November 17, 2009 at 09:20:47
 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,"+*")MIKEhttp://www.skeptic.com/

Report •

#3
November 18, 2009 at 00:54:17
 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!

Report •

Related Solutions