I added 4 columns to ALL DATA for MBDO MBPT DRDO DRPT (columns V,W,X,Y) with this formula entered in 'ALL DATA'!V4 and filled down:
Formula:
=IF(AND($H4="MB",$I4="DO"),$J4,"")
The MB and DO were changed to MB and PT, DR and DO, and DR an PT as appropriate in columns W, X and Y.
This formula was then entered in 'VOMS by MODES'!E4 and filled across and down:
Formula:
=IF(SUMIFS('ALL DATA'!V$4:V$1825,'ALL DATA'!$C$4:$C$1825,'VOMS by MODES'!$C4)=0,"",SUMIFS('ALL DATA'!V$4:V$1825,'ALL DATA'!$C$4:$C$1825,'VOMS by MODES'!$C4))
Bookmarks