Results 1 to 4 of 4

sumif: multiple critera including date

Threaded View

  1. #1
    Registered User
    Join Date
    05-07-2009
    Location
    leeds, england
    MS-Off Ver
    Excel 2007
    Posts
    29

    sumif: multiple critera including date

    hello,

    I’m trying to get the sum of a column, with specific criteria.

    In cell 3B, in the "asbestos" sheet, I would like the sum of column H in the "incidents" sheet matching the criteria:

    Incidents sheet:
    Column A = asbestos
    Column B = January

    The code I’ve tried is:

    ((Incidents!$A$4:$A$500=$a$1)*(Incidents!$C$4:$C$500>=$A4)*(Incidents!$C$4:$C$500<=DATE(YEAR($A4),MONTH($A4)+1,1))
    I’m sure there’s really simple solution to this...

    Any help much appreciated!

    many thanks

    Rich
    Attached Files Attached Files

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