Results 1 to 1 of 1
2015-11-01, 16:33 #1
- Join Date
- Jun 2005
- 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?