User Tag List

Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: Microsoft Excel Formula Problem

  1. #1
    Regular Member jka's Avatar
    Join Date
    Jun 2005
    Location
    Kirkcaldy
    Problems Posted
    0
    Problems Solved
    0
    Best Answers
    0
    Good Answers
    0
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Vehicle InfoStats





    Default Microsoft Excel Formula Problem

    I'm having difficulty working out a formula for a spreadsheet used at work and wondered if any of you guys had any good tips as to where I could get some help.

    I was going to attach a basic sample of the spreadsheet but it doesn't seem to want to upload.

    Cheers

  2. #2
    Ex Vec-C Admin & Founder Bainie's Avatar
    Join Date
    Jun 2005
    Location
    60 Degrees North !!
    Problems Posted
    0
    Problems Solved
    0
    Best Answers
    0
    Good Answers
    0
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Vehicle InfoStats





    Default

    What kind of formula are you putting in ? Is it one one sheet or a cumulative over more ?

  3. #3
    Ex Vec-C Admin / Founder Duncan's Avatar
    Join Date
    Jun 2005
    Location
    East Sussex
    Problems Posted
    0
    Problems Solved
    0
    Best Answers
    0
    Good Answers
    0
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Vehicle InfoStats





    Default

    The forum only allows certain file formats to be uploaded - Excel not being one of them. If you can describe the formula you're after - we can maybe help.

    If it's easier to see the spreadsheet to work it out, then e-mail it to me - I'm fairly competent in Excel so may be able to help.

    D

  4. #4
    Regular Member jka's Avatar
    Join Date
    Jun 2005
    Location
    Kirkcaldy
    Problems Posted
    0
    Problems Solved
    0
    Best Answers
    0
    Good Answers
    0
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Vehicle InfoStats





    Default

    It's only on one sheet. I'll try to describe what I'm doing:

    I am an Accountant and each department in my work is made up of 5 or six people. My department has a spreadsheet which summarises our client's tax returns which we have to complete.

    Columns A & B deals with client information, column C is the staff member responsible for the tax return, Colums D - F are non important stuff, column G shows the date when the Return is sent to the Inland Revenue. Column H tells you if the Return is complete by way of an IF formula (basically if there is a date in Column G then it marks that return as being complete).

    At the bottom of the spreadsheet there are the following summaries:

    Total Returns - A simple row counting formula.
    Total returns per person - Countif formula picking out individual names from the column C.

    What I need to do now is to show below each persons total returns is how many they have actaully completed but I'm stuck.

    Sorry to bore you all.

    Cheers
    John

  5. #5
    Regular Member Tim2100's Avatar
    Join Date
    Jul 2005
    Location
    Walsall
    Problems Posted
    0
    Problems Solved
    0
    Best Answers
    0
    Good Answers
    0
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Vehicle InfoStats





    Default

    do you want to email it to me?? It counds like a multiple countif function is needed.

    Tim.

  6. #6
    Ex Vec-C Admin / Founder Duncan's Avatar
    Join Date
    Jun 2005
    Location
    East Sussex
    Problems Posted
    0
    Problems Solved
    0
    Best Answers
    0
    Good Answers
    0
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Vehicle InfoStats





    Default

    Quote Originally Posted by Tim2100
    It counds like a multiple countif function is needed.
    That's what I was about to suggest

    It sounds like one of those things that is easier to suss when you see it in front of you! I'm happy to have a peek at it as well, but Tim sounds like he may be a bit more clued up than me on Excel.

    D

  7. #7
    Regular Member Tim2100's Avatar
    Join Date
    Jul 2005
    Location
    Walsall
    Problems Posted
    0
    Problems Solved
    0
    Best Answers
    0
    Good Answers
    0
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Vehicle InfoStats





    Default

    Actually thinking about it..

    If you can add another column in I it is fairly easy

    in I do a simple formula of Column c & column G =c2&g2

    In the summary at the bottom do another countif forumla based on column I. It should be countif, range would be column I, and criteria will be the name of person and "yes" ( or what ever result you get in column H if completed).. eg. =COUNTIF(columnI,(name & "yes")

    HTH. If it doesn't please feel free to email me or speak over hotmail etc.

    Tim.

  8. #8
    Regular Member jka's Avatar
    Join Date
    Jun 2005
    Location
    Kirkcaldy
    Problems Posted
    0
    Problems Solved
    0
    Best Answers
    0
    Good Answers
    0
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Vehicle InfoStats





    Default

    Thanks guys.

    I have sent a copy of the spreadsheet to Tim to have a look at.

    Cheers

    John

  9. #9
    Regular Member jka's Avatar
    Join Date
    Jun 2005
    Location
    Kirkcaldy
    Problems Posted
    0
    Problems Solved
    0
    Best Answers
    0
    Good Answers
    0
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Vehicle InfoStats





    Default

    Thanks guys.

    Tim, I have done what you said and it works a treat.

    Thanks again.

    John

  10. #10
    Regular Member Tim2100's Avatar
    Join Date
    Jul 2005
    Location
    Walsall
    Problems Posted
    0
    Problems Solved
    0
    Best Answers
    0
    Good Answers
    0
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Vehicle InfoStats





    Default

    no probs mate. Glad to help

Page 1 of 2 12 LastLast

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. microsoft xbox problem
    By nigelbriggs in forum Games Room
    Replies: 7
    Last Post: 17th January 2013, 20:23
  2. microsoft word problem
    By the fisherman in forum General Chat
    Replies: 10
    Last Post: 22nd June 2011, 20:19
  3. Microsoft Excel help required
    By siadwel in forum General Chat
    Replies: 7
    Last Post: 19th October 2009, 18:05
  4. Formula 1 on bbc.
    By thegoldenbullet in forum The 'Off Topic' room
    Replies: 6
    Last Post: 15th February 2009, 21:42
  5. Excel Formula Experts
    By Damian in forum General Chat
    Replies: 9
    Last Post: 22nd December 2006, 10:08

Visitors found this page by searching for:

Nobody landed on this page from a search engine, yet!

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
  •