• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. V

    sum if function - help required

    USING THE LEFT (A2,1) AND THEN USING SUM IF WORKED =SUMIF(E26:G38,"A",G26:G38) I AM GETTING 0 WITH SUMPRODUCT I WOULD PREFER USING A SINGLE FORMULA WHAT AM I DOING WRONG. thanks for all you help
  2. V

    sum if function - help required

    Can anyone help me with this i have to sum data in excel A040 - 4 G999 - 7 C987 - 2 D998 - 4 A140 - 6 G299 - 2 I have tried the sumif funciton by adding another helper column with only the alphabets using this formula =SUMIF(F26:H38,"A",G26:G38) i want to sum all the alphabets...
  3. V

    dynamic data transer from access query to excel

    thanks for your post i have used the microsoft.com website and got what i wanted using the pivot table report filter i have filtered the output to show the data i want.i am planning to make a dashboard with this data. thanks again
  4. V

    dynamic data transer from access query to excel

    Hello , I have created sql queries in my access database which provides data based on date fields entered by user. it works fine. I want to display the result in an excel sheet dynamically changing the date every week. 'SELECT JOBAllocations.Date, JOBAllocations.USERJOBNUM...
  5. V

    New Excel Ninja !

    i meant to say Congrats Luke now you know i am really new to the forum!!!
  6. V

    New Excel Ninja !

    Congratulations. I am quite new to the forum and i have had my post answered tirelessley by HUI.A big thank you!!!
  7. V

    Dynamic update of a consolidated spreadsheet with values from individual files

    yes just the su. The sum gets calculated in the end of each worksheet indicating the hours required to complete each project. A consolidated worksheet is available which should pull the sum only and display it in its corresponding project column and a button or refresh should do this update...
  8. V

    Dynamic update of a consolidated spreadsheet with values from individual files

    yes that is correct. i have to add an extra column that can pull the values from the sum field present on each individual log sheets. is this possible.
  9. V

    Dynamic update of a consolidated spreadsheet with values from individual files

    I have 25-30 excel spreadhseets which each records the task involved in a project and records the total time taken to do individual activites. Eg, file 1 - 35 hours - activy a file2 - 20 hours activy b file 3- 25 hours.activity c There is a consolidated spreadsheet has the description of...
  10. V

    plotting values in x axis - help required

    Value y axis crosses at category number - 1 number of categories between tick-mark labels - 1010 number of categories between tick marks - 1010 value (Y) axis crosses between categories. Is this were i key in the values. It does not take in decimal values i think. It days integer is...
  11. V

    plotting values in x axis - help required

    I have a series of time related data which i want to plot on my x axis. I want to show the time say from 1:15 pm right upto midnight 12:00 pm with a differnce of 5 seconds between each scale. how can i do it. any inputs. where can i define the starting and ending of data max and minimum.
  12. V

    chart required to plot customer complaints

    <quote> client name project name AP no of complaints client 1 Project 1 2011.01 1,2,3 client 2 Project 2 2011.01 2,4 client 1 Project 3 2011.04 3,4 client 3 Project 4 2011.06 1,5 client 4 Project 5 2011.03 1,2,3,4,5,6, 1 delayed delivery 2 QA problems 3 Technical issues 4 Lack...
  13. V

    chart required to plot customer complaints

    I am looking for ideas to plot a chart for active complaints to track open issues, over due complaints,closed complaints etc. more related to the progression of the complaint. Any inputs will be appreciated.
  14. V

    Pivot Table - filter data values

    Perfect that worked out great!! Thanks a ton.
  15. V

    Comparing static column list and automating it

    It worked like a charm. Thanks a lot for the reply. It will save a lot of typing.
  16. V

    Pivot Table - filter data values

    I am using Excel 2003 and working with Pivot tables. I have constructed a pivot table showing the sales values with all ranges and one for values >100,000. The source data is the same but the data is filtered in one and not in another. is there anyway i can use the same source data and...
  17. V

    Comparing static column list and automating it

    I already get the sum of the feild values every week. Eg. B234- 20 hours C235-10 hours The problem is i get only the code and hours worked from a crystal report and everytime i have to enter compare the static list and say there are 25 task out of 50 done and go throug each line item and...
  18. V

    Comparing static column list and automating it

    Hi All, I have a set of task codes and its corresponding task description. Weekly i run reports based on the tast done. Eg. A123- Milling B234-Cleaning C235-Sorting P878-Welding Each week the activity may change depending on the work and i get a list of codes that have been done for the...
Back
Top