Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mattagain

    Multi Conditional AverageIf Statement (excel)

    thanks guys, i have managed to get this working now, I found a formula for calculating week numbers =1+INT((A1-DATE(YEAR(A1+4-WEEKDAY(A1+6)),1,5)+WEEKDAY(DATE(YEAR(A1+4-WEEKDAY(A1+6)),1,3)))/7) one again thanks to all involved
  2. mattagain

    Multi Conditional AverageIf Statement (excel)

    i have looked at doing this by running a lookup from the date field, but i dont know how to calculate the weeknum automatically, i could do it manually, however, it would mean having to re-calculate it all each time a new spreadhseet was started
  3. mattagain

    Multi Conditional AverageIf Statement (excel)

    thanks for the help so far, i have run into a further problem i dont have access to the weeknum function, (our it dept have mislaid the excel discs, is there anyway to do this without it?
  4. mattagain

    Multi Conditional AverageIf Statement (excel)

    I am trying to create a short report from a list of data, I need to be able to quickly show weekly averages based on a specific team (i.e. if team=team1 and date is between start and end dates) on my data sheet i have the following headings :- Date / Agent / Team / Type Of Call / Quality Score...

Part and Inventory Search

Back
Top