Results 1 to 6 of 6

sumifs

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-26-2010
    Location
    usa
    MS-Off Ver
    Office 365
    Posts
    1,233

    sumifs

    Hello

    i have attached a sample workbook where i am struggling with the sumifs function.

    basically, i have provided an example in yellow in the "master" sheet.

    i need to know by the start date what city the training took place for different sales position

    i.e.
    SE/ISE - start date of training: 15-nov-2010 - Washington

    so in my master sheet i have 15-nov-2010...so i would for it to show Washigton, when i type in the date.

    my criteria will be, reference or criteria will be column H in facilitator sheet where the city name is found.....i have also tried to use ISE/SE and SE as reference in the master sheet. pls advise/
    Attached Files Attached Files
    Last edited by jw01; 03-25-2011 at 03:07 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