Hi-

Can I add 2 sumifs, because it isn't picking up the part after the plus sign.

=(SUMIFS($X$17:$X$46,$B$17:$B$46,$AF5)+SUMIFS($AG$21:$AG$26,$AF$21:$AF$26,$AF5))/1000000