| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
HELP: need to find number and sum another colmn
i have a list (wedding list of table number and how many pepole invited)
i need to calc for every colomn (famely number invited) and table belong like this (name) aa1 (pepole came) 2 (table Number) 1 (name) aa2 (pepole came) 3 (table Number) 1 (name) aa3 (pepole came) 1 (table Number) 1 (name) aa4 (pepole came) 1 (table Number) 2 (name) aa5 (pepole came) 2 (table Number) 3 (name) aa6 (pepole came) 4 (table Number) 2 i need calc of list to get the result: (for table 1) 6 (for table 2) 5 (for table 3) 2 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
need to find number and sum another colmn
Hi
try =SUMIF(C1:C100,1,B1:B100) -- Regards Frank Kabel Frankfurt, Germany "moshe" schrieb im Newsbeitrag m... i have a list (wedding list of table number and how many pepole invited) i need to calc for every colomn (famely number invited) and table belong like this (name) aa1 (pepole came) 2 (table Number) 1 (name) aa2 (pepole came) 3 (table Number) 1 (name) aa3 (pepole came) 1 (table Number) 1 (name) aa4 (pepole came) 1 (table Number) 2 (name) aa5 (pepole came) 2 (table Number) 3 (name) aa6 (pepole came) 4 (table Number) 2 i need calc of list to get the result: (for table 1) 6 (for table 2) 5 (for table 3) 2 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
need to find number and sum another colmn
Thanks it's work.
"Frank Kabel" wrote in message ... Hi try =SUMIF(C1:C100,1,B1:B100) -- Regards Frank Kabel Frankfurt, Germany "moshe" schrieb im Newsbeitrag m... i have a list (wedding list of table number and how many pepole invited) i need to calc for every colomn (famely number invited) and table belong like this (name) aa1 (pepole came) 2 (table Number) 1 (name) aa2 (pepole came) 3 (table Number) 1 (name) aa3 (pepole came) 1 (table Number) 1 (name) aa4 (pepole came) 1 (table Number) 2 (name) aa5 (pepole came) 2 (table Number) 3 (name) aa6 (pepole came) 4 (table Number) 2 i need calc of list to get the result: (for table 1) 6 (for table 2) 5 (for table 3) 2 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find previous number and find next number in column | Excel Discussion (Misc queries) | |||
| Lookup date on multiple worksheets, total amts for adjacent colmn | Excel Discussion (Misc queries) | |||
| How can we get more columns on a spreadsheet, like 365 days/colmn | Excel Worksheet Functions | |||
| can i arrange a date colmn in order of the dates by some shortcut | Excel Discussion (Misc queries) | |||
| Protect except chng colmn width | Excel Programming | |||
![moshe[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
