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

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

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