Formula

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?
 
G

Gary''s Student

To compile figures by month, consider some form of SUMPRODUCT() or a pivot
table.
 
S

ShaneDevenshire

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)
 
Top