I created the following List (named range) 1 3 5 6 9 A B C # $ Check 1 22 =IF(ISNA(MATCH(A3,List,0)),0,1) 2 11 =IF(ISNA(MATCH(A4,List,0)),0,1) . 9 45 =IF(ISNA(MATCH(A11,List,0)),0,1)
Tot =sumproduct(b3:b11,c3:c11) bunch of problems doing it like this though - so there is an easier or slicker way. What is he wanting to do? This might be fun. Eric From: Nick McClure <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]> Subject: Re: WOT: MS Excel! Help me or shot me! Date: Fri, 19 Apr 2002 10:13:51 -0400 Can't help with Excel part, but I can shoot you :) At 09:14 AM 4/19/2002 -0500, you wrote: >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 > > > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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
