Most valuable professional
  • Hot Topics

Excel Dynamic sum (non contiguous range)

Dear all I have the following spreadsheet https://1drv.ms/x/s!Av0OR27GDzktgUPrcRv_W6YdhOjy I would like to create a formulae in T4 based on a dynamic value placed in cell T2. My target is to calculate Sum all months to get to a YTD value (YTD=year to date) . Example: May 16 YTD = January+ February+March+April+May The issue that i have is that i need to ignore the greyed cells ( cells that sum quarters) I tried with OFFSET But it doesn't ignore particular cells. thanks in advance Antonio

This question generated 12 answers. To proceed to the answers, click here.

This thread is current as of June 7, 2017.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel