Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Updating rows - Excel Formula or Something Else? | Excel Worksheet Functions | |||
Formula in an Excel comment | Excel Discussion (Misc queries) | |||
Excel should have a simpler subtraction formula similar to "sum". | Excel Worksheet Functions | |||
How do I get the formula bar in excel 2003 | Excel Discussion (Misc queries) | |||
Need excel formula to display 28.50hrs in HRS & MINS? | Excel Worksheet Functions |