ExcelBanter - Formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formula (https://www.excelbanter.com/excel-discussion-misc-queries/185797-formula.html)

Wiggy

Formula

Hi,
Is there a formula for compiling monthly figures from a sheet with differant
months in it, rather than having to manually sort them?

Gary''s Student

Formula

To compile figures by month, consider some form of SUMPRODUCT() or a pivot
table.
--
Gary''s Student - gsnu200782

"Wiggy" wrote:

Hi,
Is there a formula for compiling monthly figures from a sheet with differant
months in it, rather than having to manually sort them?

ShaneDevenshire

Formula

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)
--
Cheers,
Shane Devenshire
Microsoft Excel MVP

"Wiggy" wrote:

Hi,
Is there a formula for compiling monthly figures from a sheet with differant
months in it, rather than having to manually sort them?

All times are GMT +1. The time now is 04:20 PM.