I have one of the VP's here needing some Excel help and I have been
given the job of doing it.
He wants to check a group of cells on the right (in use) and see if they
match any of the numbers on the left (#).
Then add the value of the cell next to the matching numbers ($). I tried
the SumIf function but it didn't work.
Some times it doesn't pay to be computer literate. On second thought,
just shot me.
# $ In use
--------------------------------------------------------------
1 22 1 3 5
2 11 6 9
3 33
4 44
5 22
6 32
7 56
8 12
9 45
Total
154
Phillip Broussard
Tracker Marine Group
417-873-5957
______________________________________________________________________
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
