<div>
Index &amp;&nbsp;macth will return the value from one cell rather than a range.<br />
<br />
Maybe you can use the SUMIFS function.<br />
<br />
Do you require the match function to determine which row the SUM is coming from, ie identify which row is &quot;abd&quot; and sumup that row if the header for the column is within the specified month.<br />
<br />
Thanks<br />
Rob H
</div>


Index & macth will return the value from one cell rather than a range.

Maybe you can use the SUMIFS function.

Do you require the match function to determine which row the SUM is coming from, ie identify which row is "abd" and sumup that row if the header for the column is within the specified month.

Thanks
Rob H

example.xlsx

SUMIFS-or-OFFSET.xlsx

<div>
<div class="content wysiwyg-content">
Hi Expert's excel 2007<br />
<br />
is it possible to the all the values for all the dates in a given month using a index match formula..the dates are on the horizontal match...<br />
ie.<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;01/11/2013. &nbsp; 02/11/2013. &nbsp; 03/11/2013<br />
abd. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;12. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 9. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 7<br />
cgd. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 11. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;8. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3<br />
<br />
So in my new table I want to show a total for Nov 13 of abd etc..
</div>
</div>


Hi Expert's excel 2007

is it possible to the all the values for all the dates in a given month using a index match formula..the dates are on the horizontal match...
ie.
             01/11/2013.   02/11/2013.   03/11/2013
abd.          12.                       9.                         7
cgd.           11.                      8.                         3

So in my new table I want to show a total for Nov 13 of abd etc..

index match formula to sum date for a month

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.