| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count, Countif, Sumif??
Right I've got a table that contains a lot of text that i need to summarse in another table. Its really just two columns the first contains a group name and the second a result. What I need to work out is the number of times the result occurs for each group. But every work sheet function I've entered fails. -- benjam_in ------------------------------------------------------------------------ benjam_in's Profile: http://www.excelforum.com/member.php...o&userid=36295 View this thread: http://www.excelforum.com/showthread...hreadid=560742 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count, Countif, Sumif??
Hi
=SUMPRODUCT(--(GroupRange=GroupName),--(ResultRange=ResultValue)) Arvi Laanemets "benjam_in" wrote in message ... Right I've got a table that contains a lot of text that i need to summarse in another table. Its really just two columns the first contains a group name and the second a result. What I need to work out is the number of times the result occurs for each group. But every work sheet function I've entered fails. -- benjam_in ------------------------------------------------------------------------ benjam_in's Profile: http://www.excelforum.com/member.php...o&userid=36295 View this thread: http://www.excelforum.com/showthread...hreadid=560742 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count, Countif, Sumif??
Try the pivot table wizard. This is a great way to summarize and count
when you've got multiple groups. - John benjam_in wrote: Right I've got a table that contains a lot of text that i need to summarse in another table. Its really just two columns the first contains a group name and the second a result. What I need to work out is the number of times the result occurs for each group. But every work sheet function I've entered fails. -- benjam_in ------------------------------------------------------------------------ benjam_in's Profile: http://www.excelforum.com/member.php...o&userid=36295 View this thread: http://www.excelforum.com/showthread...hreadid=560742 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count, Countif, Sumif??
need to apply it to the second table using the data from the first -- benjam_in ------------------------------------------------------------------------ benjam_in's Profile: http://www.excelforum.com/member.php...o&userid=36295 View this thread: http://www.excelforum.com/showthread...hreadid=560742 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count, Countif, Sumif??
Tried that didnt seem to work, got #NUM! error. Both the group and the results are text. -- benjam_in ------------------------------------------------------------------------ benjam_in's Profile: http://www.excelforum.com/member.php...o&userid=36295 View this thread: http://www.excelforum.com/showthread...hreadid=560742 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count, Countif, Sumif??
assuming that your data is on Sheet2!a2:b100
=sumproduct(--(a2:a100="group")*(b2:100)) hth regards from Brazil Marcelo "benjam_in" escreveu: Tried that didnt seem to work, got #NUM! error. Both the group and the results are text. -- benjam_in ------------------------------------------------------------------------ benjam_in's Profile: http://www.excelforum.com/member.php...o&userid=36295 View this thread: http://www.excelforum.com/showthread...hreadid=560742 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count, Countif, Sumif??
I have responded with an example on OzGrid. No need to post all over the
place. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "benjam_in" wrote in message ... Tried that didnt seem to work, got #NUM! error. Both the group and the results are text. -- benjam_in ------------------------------------------------------------------------ benjam_in's Profile: http://www.excelforum.com/member.php...o&userid=36295 View this thread: http://www.excelforum.com/showthread...hreadid=560742 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Forget SUMIF, COUNTIF and VLOOKUP | Excel Worksheet Functions | |||
| SUMIF vs COUNTIF | Excel Discussion (Misc queries) | |||
| Conditional Summing (Sumif? Countif?) | Excel Worksheet Functions | |||
| COUNTIF or SUMIF Problem | Excel Discussion (Misc queries) | |||
| using sumif & countif to sort multiple cells | Excel Worksheet Functions | |||
Linear Mode
