Match+sum formula
Is there a formula that will let me choose how many cells that will match
cells and also sum them using a variable. For instance if I want it to calculate from a certain month out 6 or 12 months and sum the totals. |
Hi Todd,
See SUMIF Worksheet Formula in your Excel Help. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Todd Nelson" wrote in message ... Is there a formula that will let me choose how many cells that will match cells and also sum them using a variable. For instance if I want it to calculate from a certain month out 6 or 12 months and sum the totals. |
All times are GMT +1. The time now is 04:28 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com