Change the references from relative to absolute. I didn't check the formula for accuracy just the references so that you can fill down without the references changing:
Formula:
=IF(OR(G9=0,F9="A"),SUM($C$5:$F$5,$H$5:$J$5),IF(OR(G9="A",F9=0),SUM($C$5:$E$5,$G$5:$J$5)))
Last edited by newdoverman; 12-25-2015 at 03:42 PM.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks