Formula in Excel--SUMIF
 

I have results from surveys we sent out and I need to make a database of the
results. I am more familiar with Excel than Access. We have questions that
the responder selected an answer of H, M or N. I need to be able find a
formula to find out how many H's, M's and N's there are once the database has
been entered.

Any suggestions!

THANKS!
--
Richelle

Hi Richelle

try COUNTIF instead of SUMIF
e.g.
=COUNTIF(A1:A1000,"H")

Cheers
JulieD

"Richelle" wrote in message
...
I have results from surveys we sent out and I need to make a database of
the
results. I am more familiar with Excel than Access. We have questions
that
the responder selected an answer of H, M or N. I need to be able find a
formula to find out how many H's, M's and N's there are once the database
has
been entered.

Any suggestions!

THANKS!
--
Richelle

Hi

i also notice that you received a large number of replies in
microsoft.public.worksheet.functions

please don't ask the same question in different groups as most of us who
respond to questions read a number of groups and all it does it fragment
your answers and annoy people who may have spent time working on an answer
only to discover that it has been answered in another group.

Cheers
JulieD


"Richelle" wrote in message
...
I have results from surveys we sent out and I need to make a database of
the
results. I am more familiar with Excel than Access. We have questions
that
the responder selected an answer of H, M or N. I need to be able find a
formula to find out how many H's, M's and N's there are once the database
has
been entered.

Any suggestions!

THANKS!
--
Richelle

Thanks for the response. Sorry the double posting caused a problem, but I
found the worksheet function newsgroup after I'd posted this one.

"JulieD" wrote:

Hi

i also notice that you received a large number of replies in
microsoft.public.worksheet.functions

please don't ask the same question in different groups as most of us who
respond to questions read a number of groups and all it does it fragment
your answers and annoy people who may have spent time working on an answer
only to discover that it has been answered in another group.

Cheers
JulieD


"Richelle" wrote in message
...
I have results from surveys we sent out and I need to make a database of
the
results. I am more familiar with Excel than Access. We have questions
that
the responder selected an answer of H, M or N. I need to be able find a
formula to find out how many H's, M's and N's there are once the database
has
been entered.

Any suggestions!

THANKS!
--
Richelle

no problems ... just a note for future ref :)

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Richelle" wrote in message
...
Thanks for the response. Sorry the double posting caused a problem, but I
found the worksheet function newsgroup after I'd posted this one.

"JulieD" wrote:

Hi

i also notice that you received a large number of replies in
microsoft.public.worksheet.functions

please don't ask the same question in different groups as most of us who
respond to questions read a number of groups and all it does it fragment
your answers and annoy people who may have spent time working on an
answer
only to discover that it has been answered in another group.

Cheers
JulieD


"Richelle" wrote in message
...
I have results from surveys we sent out and I need to make a database of
the
results. I am more familiar with Excel than Access. We have questions
that
the responder selected an answer of H, M or N. I need to be able find
a
formula to find out how many H's, M's and N's there are once the
database
has
been entered.

Any suggestions!

THANKS!
--
Richelle