Why not just use the compare function of CF instead of using excel? Then using <cfscript> do a loop through it if the value eq 0 add the colums etc. etc..I hope I am making sense !!!
Doug Brown ----- Original Message ----- From: "Nick McClure" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, April 19, 2002 7:13 AM Subject: Re: WOT: MS Excel! Help me or shot me! > 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 > > > > > > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
