Hi, I have a forumla that I need to run in VBA as part of a larger macro. It needs to put the formula in column "N" for all the entries in the spreadsheet. I'm not sure how to make this happen, any help is greatly appreciated. The formula is =IF(COUNTIFS($B5:B$5,B5,$F5:F$5,F5)=1,SUMIFS($D$5:$D$10000,$B$5:$B$10000,B5,$F$5:$F$10000,F5,$E$5:$E$10000,E5),"") How would I get this to work using VBA. Thanks!