Totals skipping columns
I have data that is entered into each column by different people. Each
column is totaled. Below the column total is a running total with each
column added to the last. The formula used for that column is:
=IF(AND(E18,F17),E18+F17,""). What I need is that if a column or even two is
not filled in I need the total, basically skipping the empty columns. Is
this possible?
Thanks for any help offered!!!
Mike Rogers
|