| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count if (possibly?!)
Hi, I want to count how many people gave the answer "yes" to a given
question, but I want to summarise my data by area and by account name. So, I want to know how many "Sovereign" customers in the "NW" said "yes". A1:A1000 = "Sovereign" B1:B1000 = "NW" C1:C1000 = "yes" Can anybody help? Thanks in anticipation... |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
count if (possibly?!)
Hi Kayte,
use: =sumproduct(--(a1:a1000="Sovereign")*(b1:b1000="NW")*(c1:c1000=" Yes")) hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Kayte" escreveu: Hi, I want to count how many people gave the answer "yes" to a given question, but I want to summarise my data by area and by account name. So, I want to know how many "Sovereign" customers in the "NW" said "yes". A1:A1000 = "Sovereign" B1:B1000 = "NW" C1:C1000 = "yes" Can anybody help? Thanks in anticipation... |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
count if (possibly?!)
Kayte, see if this will do it,
=SUMPRODUCT((A1:A25="Sovereign")*(B1:B25="NW")*(C1 :C25="yes")) -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Kayte" wrote in message ... Hi, I want to count how many people gave the answer "yes" to a given question, but I want to summarise my data by area and by account name. So, I want to know how many "Sovereign" customers in the "NW" said "yes". A1:A1000 = "Sovereign" B1:B1000 = "NW" C1:C1000 = "yes" Can anybody help? Thanks in anticipation... |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
count if (possibly?!)
hi, thanks for your help.
I had been trying this based on other posts but for some reason it's returning '#value!' - a value used in this formula is of the wrong data type... "Paul B" wrote: Kayte, see if this will do it, =SUMPRODUCT((A1:A25="Sovereign")*(B1:B25="NW")*(C1 :C25="yes")) -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Kayte" wrote in message ... Hi, I want to count how many people gave the answer "yes" to a given question, but I want to summarise my data by area and by account name. So, I want to know how many "Sovereign" customers in the "NW" said "yes". A1:A1000 = "Sovereign" B1:B1000 = "NW" C1:C1000 = "yes" Can anybody help? Thanks in anticipation... |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
count if (possibly?!)
Do you have any errors in any of those ranges?
Remember to look in any hidden rows (is autofilter on?) And if that doesn't help, post the formula you tried. Kayte wrote: hi, thanks for your help. I had been trying this based on other posts but for some reason it's returning '#value!' - a value used in this formula is of the wrong data type... "Paul B" wrote: Kayte, see if this will do it, =SUMPRODUCT((A1:A25="Sovereign")*(B1:B25="NW")*(C1 :C25="yes")) -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Kayte" wrote in message ... Hi, I want to count how many people gave the answer "yes" to a given question, but I want to summarise my data by area and by account name. So, I want to know how many "Sovereign" customers in the "NW" said "yes". A1:A1000 = "Sovereign" B1:B1000 = "NW" C1:C1000 = "yes" Can anybody help? Thanks in anticipation... -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
count if (possibly?!)
Hi, thanks for your help. It's returning #value! - "a value used in this
formula is of the wrong data type". (apologies for the late reply - for some reason my earlier reply didn't appear!) "Paul B" wrote: Kayte, see if this will do it, =SUMPRODUCT((A1:A25="Sovereign")*(B1:B25="NW")*(C1 :C25="yes")) -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Kayte" wrote in message ... Hi, I want to count how many people gave the answer "yes" to a given question, but I want to summarise my data by area and by account name. So, I want to know how many "Sovereign" customers in the "NW" said "yes". A1:A1000 = "Sovereign" B1:B1000 = "NW" C1:C1000 = "yes" Can anybody help? Thanks in anticipation... |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
count if (possibly?!)
look in the help index for COUNTIF
-- Don Guillett SalesAid Software "Kayte" wrote in message ... Hi, I want to count how many people gave the answer "yes" to a given question, but I want to summarise my data by area and by account name. So, I want to know how many "Sovereign" customers in the "NW" said "yes". A1:A1000 = "Sovereign" B1:B1000 = "NW" C1:C1000 = "yes" Can anybody help? Thanks in anticipation... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need formula to count spinoffs | Excel Worksheet Functions | |||
| Subtotals by count | Excel Discussion (Misc queries) | |||
| Count consecutive dates only | Excel Discussion (Misc queries) | |||
| Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
| Conversion | Excel Worksheet Functions | |||
Hybrid Mode
