Results 1 to 7 of 7

returning value if month is January

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-05-2006
    Posts
    113

    returning value if month is January

    I have a list of data (1000 rows).
    Each row has several columns containing information on a given transaction.

    column F contains the date of the transaction (mm/dd/yyyy format.)
    column M contains a dollar amount.

    I have two formulas that I need to make that i am not sure how to handle.

    1. I want formula that will count all the cells in column F that have a month of January and a year of 2006 and give me a total for the number of rows that contain this. I tried: =COUNTIF(F2:F1000,MONTH(1)) but it did not work.

    2. I want a formula that will add up the sum ($) of all the cells in column M if the month in column F is January and the year is 2006.
    Last edited by jermsalerms; 08-18-2006 at 02:00 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