Thanks Ashish, this is exactly what in was looking for. I understand that a "$" sign will freeze the range, what is the technical function of the "&"?
From: ashish koul [mailto:koul.ash...@gmail.com] Sent: Saturday, March 26, 2011 9:21 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Sum If FOR EXAMPLE CE5 is having date =SUMIF($F$5:$BM$5,"="&CE5,$F7:$BM7) On Sun, Mar 27, 2011 at 6:29 AM, Pehrson, Dave <dpehr...@walbro.com> wrote: In the sumif function shown below, I'm referencing a date: ,"=04/25/2011" =SUMIF($F$5:$BM$5,"=04/25/2011",$F7:$BM7) The Date is in cell "F5" Is there a way to rewrite the "sumif" function to reference the cell vs. the actual date? The attached worksheet shows the formula I'm working with in Col. BN to CE Any help would be appreciated. Kindest Regards Dave -- ------------------------------------------------------------------------ ---------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Regards Ashish Koul akoul.blogspot.com <http://akoul.blogspot.com/> akoul.wordpress.com <http://akoul.wordpress.com/> My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830> P Before printing, think about the environment. -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
<<image001.gif>>
