If have this formula "SUM(IF(D81=0,C81,0),IF(D82=0,C82,0),IF(D83=0,C83,0),IF(D84=0,C84,0))" but I don't want to extend that out to 100 cells, isn't there an easier way to make this scalable?
Thanks
If have this formula "SUM(IF(D81=0,C81,0),IF(D82=0,C82,0),IF(D83=0,C83,0),IF(D84=0,C84,0))" but I don't want to extend that out to 100 cells, isn't there an easier way to make this scalable?
Thanks
Last edited by Bkeith; 08-27-2013 at 09:10 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks