Results 1 to 10 of 10

Formula that looks at the text and month and then adds the correct numbers

Threaded View

scrim Formula that looks at the... 01-12-2011, 06:19 PM
shg Re: formula help 01-12-2011, 06:23 PM
arthurbr Re: Formula that looks at the... 01-13-2011, 03:18 AM
e4excel Re: Formula that looks at the... 01-13-2011, 04:07 AM
DonkeyOte Re: Formula that looks at the... 01-13-2011, 04:17 AM
e4excel Re: Formula that looks at the... 01-13-2011, 04:31 AM
arthurbr Re: Formula that looks at the... 01-13-2011, 04:33 AM
e4excel Re: Formula that looks at the... 01-13-2011, 04:04 PM
  1. #1
    Registered User
    Join Date
    01-12-2011
    Location
    Chicago, US
    MS-Off Ver
    Excel 2007
    Posts
    2

    Formula that looks at the text and month and then adds the correct numbers

    What I have is the following information,
    \1

    I am trying to figure out a formula that adds up only the totals for John Smith in January. I think I need to combine an IF with a SUMIF but I can't get it to work. What formula will work?

    So far I've worked out:
    =SUMIF(C2:C7,">="&DATE(2011,1,1),B2:B7)-SUMIF(C2:C7,">"&DATE(2011,1,31),B2:B7)
    But I can't get to the next level that would look at my employees before looking at the dates
    Attached Files Attached Files
    Last edited by scrim; 01-13-2011 at 11:43 AM. Reason: added excel workbook

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