Nov 12, 2003 #1 APElliott Technical User Jul 9, 2002 165 GB I really can't get my head round inserting formula's! Can anybody show me the way with this one: [h3].Formula = "=Round(Subtotal(9,BoQ!m3:m65536)-(SumIf(f4:f65536),"">0"",(f4:f65536),2)" Thanks, Andrew
I really can't get my head round inserting formula's! Can anybody show me the way with this one: [h3].Formula = "=Round(Subtotal(9,BoQ!m3:m65536)-(SumIf(f4:f65536),"">0"",(f4:f65536),2)" Thanks, Andrew
Nov 12, 2003 Thread starter #2 APElliott Technical User Jul 9, 2002 165 GB Sorry, Just got it! [h3].Formula = "=ROUND(SUBTOTAL(9,BoQ!M3:M65536)-SUMIF(F4:F65536,"">0"",F4:F65536),2)" Andrew Upvote 0 Downvote
Sorry, Just got it! [h3].Formula = "=ROUND(SUBTOTAL(9,BoQ!M3:M65536)-SUMIF(F4:F65536,"">0"",F4:F65536),2)" Andrew