Formula

  • Thread starter Thread starter Wiggy
  • Start date Start date
W

Wiggy

Hi,
Is there a formula for compiling monthly figures from a sheet with differant
months in it, rather than having to manually sort them?
 
To compile figures by month, consider some form of SUMPRODUCT() or a pivot
table.
 
Hi,

We really don't have enough info here to answer this - show us a sample of
the data.

You might just use SUMIF(MonthsRange,Month,SumRange)
 

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

Back
Top