J
jonathanscary
Hi
I have a spreadsheet with the following data in range A1:B12 i
Worksheet 1:
North 1
North #N/A
North 4
South 2
South #N/A
South 1
South #N/A
East 1
East #N/A
West 1
West #N/A
West 2
In Worksheet 2, I have the following data in range A1:A4
North
South
East
West
In B2:B4 (Worksheet 2) I'd like to display the totals for eac
geographical area, thus:
North 5
South 2
East 1
West 3
I've been driving myself nuts all day with this. Can anybody help?
I've put a sample file in attachment.
Thank
Attachment filename: book1.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=62359
I have a spreadsheet with the following data in range A1:B12 i
Worksheet 1:
North 1
North #N/A
North 4
South 2
South #N/A
South 1
South #N/A
East 1
East #N/A
West 1
West #N/A
West 2
In Worksheet 2, I have the following data in range A1:A4
North
South
East
West
In B2:B4 (Worksheet 2) I'd like to display the totals for eac
geographical area, thus:
North 5
South 2
East 1
West 3
I've been driving myself nuts all day with this. Can anybody help?
I've put a sample file in attachment.
Thank
Attachment filename: book1.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=62359