Results 1 to 6 of 6

Thread: sumifs in VBA

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 05-08-2009, 06:33 AM #5
    Paul_Hossler
    Paul_Hossler is offline
    VBAX Sage
    Joined
    Apr 2007
    Location
    United States
    Posts
    8,894
    Location
    Don't have a sample work book (hint, hint) but it looks like the arguments might be out of order, in addition to the other comments

    SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], …)
    eng_hours = Application.WorksheetFunction.SumIfs(mtd_ttl_hours, maj_group, "ENG", bill_summary, "LABOR")
    Paul
    Last edited by Aussiebear; 05-04-2025 at 11:12 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules