Results 1 to 4 of 4

If/And/Vlookup question

Threaded View

  1. #1
    Registered User
    Join Date
    08-19-2005
    Posts
    2

    If/And/Vlookup question

    Hi all,

    I have a spreadsheet set up as follows:
    Column A = dates in month/day/year format
    Column E = number of hours
    Column F = $ rate associated with the hours in Column E
    Column I = Total of Column E X Column F

    In Column J I would like to do the following, but I'm not sure what's the most efficient way of doing it. I would like to summarize the Total amount in Column I for each month and year. For example, I would like to add the totals from Column I for all the data for the month of May, 2004 (dates in Column A). I understand I can add a row under each each month and subtotal the months that way, but I would prefer to do this seperate from the original data in Columns A-I.

    Is this possible?

    Thanks!
    Last edited by hoosonfirst; 08-19-2005 at 11:46 AM.

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