Here's what I want Excel2007 to do:
Scan column B for H2, scan column C for I2; for each match please add up
the numbers found in column E and give me a total.
In other words... In H2 is KIX and in I2 is NYC
B.......C.............E
KIX....NYC..........3
NRT....LAX.........4
NGO....SFO.........1
KIX.....NYC.........2
For KIX NYC the total would be 5.
This is sort of a countif/sumif combo methinks. Any ideas are appreciated!
Bookmarks