help needed in excel 07

Mar 26, 2013
Reaction score
Any one help me solve this question in excel 2007 :( :(

The Salesworksheet contains 48 months of sales at a toy store. Create an array formula
to add (beginning with Month 3) every fifth month of sales. (Hint: You might want
to use the Excel MOD function. MOD(number,divisor)yields the remainder after the
number is divided by the divisor. For example, MOD(7,5)yields 2. Use concept of Array formulae and function

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question