HELP: need to find number and sum another colmn

M

moshe

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum of sub groups 3
Special sum of texts 8
I need ONLY subtotals copied to a second sheet 4
I need to give index number to charts 3
Need VBA solution to find 1st and 2nd occurrences of non- zero, thenreturn column header value 4
Comparing Model Numbers without a giant IF statement 2
Get/Find criteria and copy sum 2
Need Excel Macro to select an unknown, named table and convert it toa range 1

Top