Return Sum value of one column from cells not blank in another column
I have a table with Net and Gross data in 2 columns. In the rest of the columns there are years (2010,2011,2012,2013). For the years that have a 1 (and is not blank) is it possible to sum the corresponding values from Net or gross on the same row. Without using a pivot table.
Please look at the attached example.
Probably easy to do, but I am rubbish on excel!
|