| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
