Formulas within VBA
Good Day All!,
I am going crazy with an issue and am hoping that someone can give me some advice. I just wanted to find out if it is possible to make the following formula work within VBA. Right now it is too many characters for (1) Excel Cell and the amount of formulas in my overall spreadsheet takes FOREVER to load. If it's possible and someone could explain how, I'd be greatly appreciative.
The formula:
=COUNTIFS('OEF Equipment Tracker Upload'!C:C,"A0021",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"A0025",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"A0030",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"A0061",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"A0067",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"A0142",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"A0149",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"A0153",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"A0194",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"A0271",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"A0286",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"A1503",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"A1520",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"A2179",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"A3232",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"A9003",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"B0015",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"B0018",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"B0024",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"B0025",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"B0035",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"B0038",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"B0040",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"B0058",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"B0060",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"B0063",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"B0065",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"B0078",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"B0093",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"B0096",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"B0160",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"B0392",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"B0395",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"B0446",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"B0589",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"B0626",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"B0640",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"B1082",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"B1583",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"B1785",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"B1922",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"B2127",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"B2460",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"B2462",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"B2464",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"B2483",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"B2561",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"B2565",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"B2566",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"B2567",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"B2685",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"B2686",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"B2687",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"C7007",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"C7033",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"C7905",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"D0002",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"D0003",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"D0005",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"D0007",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"D0008",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"D0009",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"D0013",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"D0015",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"D0016",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"D0017",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"D0022",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"D0023",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"D0025",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"D0027",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"D0030",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"D0033",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"D0034",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"D0035",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"D0036",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"D0040",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"D0080",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"D0085",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"D0209",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"D0215",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"D0235",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"D0850",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"D0860",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"D0861",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"D0876",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"D0878",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"D0880",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"D0886",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"D0887",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"D1001",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"D1063",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"D1214",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"E0067",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"E0069",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"E0070",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"E0150",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"E0671",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"E0942",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"E0946",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"E0947",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"E0948",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"E0949",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"E0950",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"E0996",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"E1378",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"E1500",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"E1888",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"A0122",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"A1440",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"A1957",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"A2306",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"A3200",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"A3270",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"B0033",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"B0034",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"B0057",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"B0092",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"B0094",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"B0391",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"B1298",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"B1582",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"B1951",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"B2394",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"D0004",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"D0006",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"D0187",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"D0201",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"D0877",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"D0881",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"D1062",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"D1064",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"D1125",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"D1158",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")+COUNTIFS('OEF Equipment Tracker Upload'!C:C,"E1070",'OEF Equipment Tracker Upload'!Y:Y,"CMBA",'OEF Equipment Tracker Upload'!O:O,"DLA-DS",'OEF Equipment Tracker Upload'!AA:AA,"")
I hope it's possible. I may be asking the impossible. Thanks!
Respectfully,
Paul Freitas
I suggest you invest some
I suggest you invest some time looking at pivot tables..
It will be possible to create the results you are looking for using a pivot table... formulae that big will encourage errors in calculation...