+ Reply to Thread
Results 1 to 3 of 3

Count if

  1. 01-07-2009, 05:54 PM #1
    ramia1983
    ramia1983 is offline
    Registered User
    Join Date
    03-18-2008
    Posts
    17

    Count if

    Lets say i have 2 cols:
    Col A has the dates 01/01/08 all the way to 12/31/08
    Col B has some numbers specifing the meter reading for that day.(not all dates will have a meter reading)

    How would i count how many meter reading i have for the month of march.(03/01/08 to 03/31/08).
    Last edited by ramia1983; 01-07-2009 at 06:10 PM.
    Reply With QuoteRegister To Reply
  2. 01-07-2009, 06:01 PM #2
    jasoncw
    jasoncw is offline
    Forum Expert
    Join Date
    12-29-2004
    Location
    Michigan, USA
    MS-Off Ver
    2013
    Posts
    2,208
    Try this formula:

    =SUMPRODUCT((MONTH(A1:A366)=3)*(B1:B366<>""))

    HTH

    Jason
    Reply With QuoteRegister To Reply
  3. 01-07-2009, 06:10 PM #3
    ramia1983
    ramia1983 is offline
    Registered User
    Join Date
    03-18-2008
    Posts
    17
    Thank You very much
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1