I have the following formula in a cell
=LEN(SUBSTITUTE(A1,",",""))
This is for counting data such as:
1,2,3,4

is it possible to use 2 criterias?
tia

Help...I have created a spread sheet and I need to change the font color to
red on all the negarive numbers. I tried searching for but it doesnt' work.
Help ahain..thx

I need help in changing the font color for negative numbers to red in a
spread sheet
I have tried searching and then find using -$  find and it doesnt seem to work

Last week I could select multiple contiguous celss (with values) and see the
sum displayed at the lower right corner of my monitor.  Now I cannot see the
sum anymore.  What happened and how do I regain the ability to see the sum?

I'm trying to do bring some information from access to excel, but
sometimes I have a criteria and sometimes I don't need a criteria.
For example: I can choose only the month January in my criteria, or if
I put nothing it will bring all year of 2007.

It looks (print preview) and prints complete, but when I convert to a pdf it
cuts off the bottom half of both my pages.  It also mentions something about
tags and bookmarks. Please help.
Thanks

Having bothered others with ways of parsing names, I thought I'd at lease
contribute a simple solution for doing the complete job...
Assume you have names of the following types in column C
    Mrs Dorothy Hannity

[Excel 2003] Assume a worksheet with with numbers in column A; Boolean
criterion [Y or N] in column B; and another Boolean criterion [Y or N]
in column C.  I would like to add the numbers in column A for all rows
that have 'y' in both columns B and C.

any clues as to why i get grand totals, and sometimes i dont.
occassionally i go over my numbers and fix errors and suddenly the
grand total appears.
but sometimes i dont find any errors and it still doesnt appear.

If I have to, I'll apply this hotfix through some sort of AD script, but
ideally, WSUS should handle it.  Has MS offered anything on whether or not
WSUS will be able to push down this patch?
Thanks!

I have to compile data from a hundred word docs. It's a survey with multiple
questions. What id like to do is have a button in excel that I can click,
and it just keeps adding 1 to the desired cell so I can keep track of how
many times I see that particular answer on the word ...

How do you sort data into columns without replacing other columns with data?
Example:
Column A:                                               Column B:   Column C:
Cost Ctr Asset Doc. No. Amount Cum. Amt  

Can anybody help me with a dilemma I have in excel. It all revolves around
calendar dates, dates from and dates to and dates in between.
What I am trying to do is construct a spreadsheet which will show me a date
in the future from a date I have entered.

[Excel 2003]
I have a worksheet that looks something like this:
A                  B                 C
Charge          Payable        Paid