Hi,
I have 2 conditions in two cells and I need these conditions to be combined in one cell, below are the conditions:
=IF($X$5="Global",SUMIFS(Galaxy_Data!$T$2:$T$471,Galaxy_Data!$E$2:$E$471,'It would take'!$X$5,Galaxy_Data!$B$2:$B$471,'It would take'!$V$9)/2,SUMIFS(Galaxy_Data!$T$2:$T$471,Galaxy_Data!$D$2:$D$471,'It would take'!$X$5,Galaxy_Data!$B$2:$B$471,'It would take'!$V$9)/2)
=SUMIFS(Galaxy_Data!$T$473:$T$942,Galaxy_Data!$B$473:$B$942,'It would take'!$V$9,Galaxy_Data!$D$473:$D$942,'It would take'!$X$5)/2
Can you please help?
I have 2 conditions in two cells and I need these conditions to be combined in one cell, below are the conditions:
=IF($X$5="Global",SUMIFS(Galaxy_Data!$T$2:$T$471,Galaxy_Data!$E$2:$E$471,'It would take'!$X$5,Galaxy_Data!$B$2:$B$471,'It would take'!$V$9)/2,SUMIFS(Galaxy_Data!$T$2:$T$471,Galaxy_Data!$D$2:$D$471,'It would take'!$X$5,Galaxy_Data!$B$2:$B$471,'It would take'!$V$9)/2)
=SUMIFS(Galaxy_Data!$T$473:$T$942,Galaxy_Data!$B$473:$B$942,'It would take'!$V$9,Galaxy_Data!$D$473:$D$942,'It would take'!$X$5)/2
Can you please help?