+ 0 Votes Try This dogknees August 17, 2013 at 9:14pm PST If you want to have the second sum when ALL the conditions are true. =IF(AND(C2="YES", C3="YES", C4="NO", C5="YES", C6="No"),SUM(B2,B3,B5),SUM(B2,B3,B4,B5,B6)) If you want the second sum when ANY of the conditions are true. =IF(OR(C2="YES", C3="YES", C4="NO", C5="YES", C6="No"),SUM(B2,B3,B5),SUM(B2,B3,B4,B5,B6)) Hope that helps dogknees + 0 Votes Thanks for the reply. TrundleButt August 19, 2013 at 1:51pm PST It works for exactly what i posted but I was hoping for some freedom with it, It's basically some bills are monthly some are weekly etc and I'm trying to calculate it by weekly, so 3 times some are ignored and some aren't so could you explain it a little so maybe I could expand/modify it to my own means? Thanks + 0 Votes Define a variable tmalo627 August 20, 2013 at 2:50pm PST You can either define your variable nested inside an =if formula, or use a cell off to the side of your table to define it. What type of criteria are you wanting the fluidity with?