+ Reply to Thread
Results 1 to 2 of 2

SUMIF problems

  1. #1
    Registered User
    Join Date
    01-21-2007
    Location
    UK
    Posts
    26

    SUMIF problems

    Hi,



    I am doing the following SUMIF

    =sumif($r$60:$az$60,<=$i$3,$r$64:$az$64)

    if i type the date it works-- however this date will change constantly and i cant update the date in the formula all the time
    =sumif($r$60:$az$60,"<=01/01/2007",$r$64:$az$64)

    r60:az60 is the date range
    i3 is a date
    r64:az60 is the numbers toi be summed range

    i want to only sum the data if its corresponding date range is less than or equal to the set date in I3, but i cant figure out the correct syntax

    help!

    thanks
    Last edited by garethgtt; 01-28-2007 at 10:23 PM.

  2. #2
    Registered User
    Join Date
    01-21-2007
    Location
    UK
    Posts
    26
    oooh am i right in thinking this works:

    =SUMIF($R$60:$AZ$60,"<="&I3,$R$64:$AZ$64)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1