Search:

Type: Posts; User: DGStewart; Keyword(s):

Search: Search took 0.00 seconds.

  1. I discovered that too but it still requires a...

    I discovered that too but it still requires a manual search of 4,000 accounts. Can you think of way to automate a search for the variances? Eventually I will have grouped by neighborhood but those...
  2. Sample file attached

    I have attached a small sample file. Our actual data file has additional columns and over 18,000 lines of data. I appreciate your help on this and your past help too.

    33554
  3. Auditing utility accounts (with pivot table?)

    I work for a City and we bill for water sewer and garbage.

    I want to audit the accounts and make sure that the appropriate services are on each account. I have used ODBC to access the data tables...
  4. Suppressing page numbers on TOC when using Heading 1

    Is there a way for the table of contents in Word 2010 to suppress page numbers when heading 1 is used? Heading 2 would page numbers.

    Example of what it might look like. Items in blue would be a...
  5. Replies
    2
    Views
    422

    Problem solved.

    Problem solved.
  6. Replies
    2
    Views
    422

    Additional info. I am using Word 2010 and my...

    Additional info.

    I am using Word 2010 and my documents have section breaks.
  7. Replies
    2
    Views
    422

    TOC isn't working

    Well I thought I just had one problem but find I have two.

    I have a document that had a table of contents and I ended up removing it as it was causing my document to be unstable. I then tried...
  8. Adding amounts across multiple spreadsheets within a date range

    I am needing to add amounts from several spreadsheets to create a summary of payments received by month and year. Can someone tell me what is the easiest method for accomplishing this? i.e....
  9. Replies
    6
    Views
    714

    Thanks for the tip. I added the = signs as you...

    Thanks for the tip. I added the = signs as you mentioned into RG's formula and the answer was good. Oddly enough, it didn't seem to matter whether they were present in the formula.
  10. Replies
    6
    Views
    714

    That worked perfectly but I don't understand why....

    That worked perfectly but I don't understand why. I understand >229 but <334 would make me think that I wouldn't pull in any 334's. Additionally, >334 makes sense but <339 seems like I would miss...
  11. Changing formulas to point to new column in budget

    I am working on budget files and while it's not that troublesome to change the formula's manually as we move from requested to proposed to adopted, etc., maybe someone knows of an easier way to do...
  12. Replies
    6
    Views
    714

    Oops. know not no

    Oops. know not no
  13. Replies
    6
    Views
    714

    Sumifs within a range

    Help!

    In one column I need a sumifs formula that will add elements 330-334
    In the next column I need a sumifs formula that will add elements 335-339

    I have tried using ...
  14. Replies
    5
    Views
    1,955

    I couldn't get this one to work. Missing...

    I couldn't get this one to work. Missing argument. I was able to subtract sumifs as mentioned by RetiredGeek. Thanks to both of you. I do appreciate your help. New sumifs question on its way.
  15. Replies
    5
    Views
    1,955

    This also does not work. ...

    This also does not work.

    =SUMIFS($M$3:$M$26,$B$3:$B$26,"301",$D$3:$D$26,">501",$D$3:$D$26, "<597",$F$3:$F$26,"=6*")
  16. Replies
    5
    Views
    1,955

    Sumifs Question using Excel 2010

    I have a budget spreadsheet using sumifs but have not figured out how to exclude certain data to prevent duplicates in my sum. I have attached a sample spreadsheet that should give the basics of...
Results 1 to 16 of 16