However, if the color is determined by Conditional Formatting, then you can use the same Formulas you used there in SUMIF or SUMIFS formulas to return the total for each color.
See:
https://www.ablebits.com/office-addins-blog/2014/11/12/excel-sumifs-sumif-multiple-criteria/
Thanks for the reply Joe. I tried to use the sumif formula to return the sum using the same formula I used for conditional formatting, but the conditional formatting is setup on approx. every 3rd column for 360 columns and the formula didn't return the number correctly and was very cumbersome. I pasted the sumif formula I tried to use below:
=SUMIF((F:F,I:I,L:L,O:O,R:R,U:U,X:X,AA:AA,AD:AD,AG:AG,AJ:AJ,AM:AM,AP:AP,AS:AS,AV:AV,AY:AY,BB:BB,BE:BE,BH:BH,BK:BK,BN:BN,BQ:BQ,BT:BT,BW:BW,BZ:BZ,CC:CC,CF:CF,CI:CI,CL:CL,CO:CO,CR:CR,CU:CU,CX:CX,DA:DA,DD:DD,DG:DG,DJ:DJ,DM:DM,DP:DP,DS:DS,DV:DV,DY:DY,EB:EB,EE:EE,EH:EH,EK:EK,EN:EN,EQ:EQ,ET:ET,EW:EW,EZ:EZ,FC:FC,FF:FF,FI:FI,FL:FL,FO:FO,FR:FR,FU:FU,FX:FX,GA:GA,GD:GD,GG:GG,GJ:GJ,GM:GM,GP:GP,GS:GS,GV:GV,GY:GY,HB:HB,HE:HE,HH:HH,HK:HK,HN:HN,HQ:HQ,HT:HT,HW:HW,HZ:HZ,IC:IC,IF:IF,II:II,IL:IL,IO:IO,IR:IR,IU:IU),AND(F7<>0,D$6<=($B7+28)),(F:F,I:I,L:L,O:O,R:R,U:U,X:X,AA:AA,AD:AD,AG:AG,AJ:AJ,AM:AM,AP:AP,AS:AS,AV:AV,AY:AY,BB:BB,BE:BE,BH:BH,BK:BK,BN:BN,BQ:BQ,BT:BT,BW:BW,BZ:BZ,CC:CC,CF:CF,CI:CI,CL:CL,CO:CO,CR:CR,CU:CU,CX:CX,DA:DA,DD:DD,DG:DG,DJ:DJ,DM:DM,DP:DP,DS:DS,DV:DV,DY:DY,EB:EB,EE:EE,EH:EH,EK:EK,EN:EN,EQ:EQ,ET:ET,EW:EW,EZ:EZ,FC:FC,FF:FF,FI:FI,FL:FL,FO:FO,FR:FR,FU:FU,FX:FX,GA:GA,GD:GD,GG:GG,GJ:GJ,GM:GM,GP:GP,GS:GS,GV:GV,GY:GY,HB:HB,HE:HE,HH:HH,HK:HK,HN:HN,HQ:HQ,HT:HT,HW:HW,HZ:HZ,IC:IC,IF:IF,II:II,IL:IL,IO:IO,IR:IR,IU:IU))
It is possible that my criteria is incorrectly written for the sumif but regardless my range cannot be a solid range and is very difficult to work with. I am looking for some way to get the sum with a much simpler formula and thought VBA might be able to provide that.
Thanks.