basic sumif function help (urgent)

hey guys,

i need help with a basic sumif function. i have three seperate worksheets, and on the first worksheet i have various months -- which i am trying to calculate total expenses for. on the third worksheet, i have various purchases i made throughout the month.

i am trying to join both details into my first worksheets sums by using a sumif function. i would like the sum of my expenses, increased by the rate of inflation (which i have specified as 2% in an assumptions table beneath the first worksheets main details).

How can I formulate a function for this?

BTW. I have attached the actual workbook for ease of understanding.

Thanks for all your help.

=SUMPRODUCT(--(Sheet3!MONTH($A$2:$A$200)=1),Sheet3!$B$2:$B$200)*(1+H1)

gets the Jan total, assuming the 2% is in H1


--

HTH

RP
(remove nothere from the email address if mailing direct)


"sentil" <[email protected]> wrote in
message news:[email protected]...
>
> hey guys,
>
> i need help with a basic sumif function. i have three seperate
> worksheets, and on the first worksheet i have various months -- which i
> am trying to calculate total expenses for. on the third worksheet, i
> have various purchases i made throughout the month.
>
> i am trying to join both details into my first worksheets sums by using
> a sumif function. i would like the sum of my expenses, increased by the
> rate of inflation (which i have specified as 2% in an assumptions table
> beneath the first worksheets main details).
>
> How can I formulate a function for this?
>
> BTW. I have attached the actual workbook for ease of understanding.
>
> Thanks for all your help.
>
>
> +-------------------------------------------------------------------+
> |Filename: thomson_a3.zip |
> |Download: http://www.excelforum.com/attachment.php?postid=4102 |
> +-------------------------------------------------------------------+
>
> --
> sentil
> ------------------------------------------------------------------------
> sentil's Profile:
http://www.excelforum.com/member.php...o&userid=29407
> View this thread: http://www.excelforum.com/showthread...hreadid=491186
>