Results 1 to 6 of 6

SumIF with Dates

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-26-2008
    Posts
    124

    SumIF with Dates

    In the expense log, Column C is a list of Dates and Column I is a list of expenses. I want to Sum the expenses in the 'Expense Log 09' to a new sheet based on a Date entered in H24 on the new sheet. I have tried the formula as shown below and Get the result #NAME?

    =SUM(IF(Expense Log 'Expenses Log 09'!C8:C100,H24,'Expenses Log 09'!I8:I100))

    I would Like to SUM all expenses After the posted date including that date.

    Thanx

    Jim O
    Last edited by JOGIER; 02-13-2009 at 04:41 PM.

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