Results 1 to 1 of 1
  1. #1
    3 Star Lounger
    Join Date
    Jun 2005
    Posts
    386
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Combining amounts from two different schedules into one schedule

    I have been using SUMIFS formula and ran into a situation where I want to combine the SUMIFS formula on to CORP BASIC DATA,
    from two different source schedules WITHIN the same worksheet DEPT BASIC DATA.

    The first source schedule will look at a sumrange from cells G13:G233 where criteria range 1 is D13233 AND criteria range 2 is C13:C233.

    The second source schedule will look at a sumrange from cells P14:T59 where criteria range 1 is N14:N59 AND criteria range 2 is P12:T12

    I tried to combine and it seems that on the second sumrange using the criteria range 1 going vertical and the criteria range 2 going horizontal.

    Does anyone have any thoughts?

    (workbook attached)

    Thank you.
    Attached Files Attached Files

Posting Permissions

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