|
|
#1
08-13-2014, 06:42 AM
|
|||
|
|||
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! 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Macro to remove blank column
|
netchie | Word VBA | 4 | 03-14-2013 02:22 PM |
| Summing Non Contiguous Cells in a Row or Column | Joe Ottenhof | Excel | 4 | 12-19-2012 04:13 AM |
| as the return value of another column, using Listbox? | marreco | Excel Programming | 1 | 03-27-2012 12:48 PM |
| Can I change the horizontal scrollbar to scroll smoothly rather than column by column | carpat | Excel | 0 | 01-10-2012 09:34 AM |
|
Need to search a column for a macth and return a result from a third column
|
pdfaust | Excel | 2 | 02-03-2011 03:02 PM |
Windows 8 
Office 2013
Threaded Mode