Hello folks,
I have a spreadsheet that has (in sheet 2) column H with a number of days in
stock (1-60+) and the profit for that vehicle in column W. I want to add all
the profit for the vehicles that are in stock between 31 and 45 days for
example. i.e. if column H is between 31 and 45 what is the corresponding
profit in column W. This then would enable me to calculate the total/average
profit for any age band. The bands will be 1-30, 31-45, 46-60 and 61+.
Thank you in anticipation.

=SUMIF(H:H,">30",W:W)-SUMIF(H:H,">45",W:W)

etc.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Bruce Hancock" <(E-Mail Removed)> wrote in message
news:C6DC536E-BD9A-48C6-AFCB-(E-Mail Removed)...
> Hello folks,
> I have a spreadsheet that has (in sheet 2) column H with a number of days
> in
> stock (1-60+) and the profit for that vehicle in column W. I want to add
> all
> the profit for the vehicles that are in stock between 31 and 45 days for
> example. i.e. if column H is between 31 and 45 what is the corresponding
> profit in column W. This then would enable me to calculate the
> total/average
> profit for any age band. The bands will be 1-30, 31-45, 46-60 and 61+.
> Thank you in anticipation.

Spot on thank you Bob!

"Bob Phillips" wrote:

> =SUMIF(H:H,">30",W:W)-SUMIF(H:H,">45",W:W)
>
> etc.
>
> --
> HTH
>
> Bob
>
> (there's no email, no snail mail, but somewhere should be gmail in my addy)
>
> "Bruce Hancock" <(E-Mail Removed)> wrote in message
> news:C6DC536E-BD9A-48C6-AFCB-(E-Mail Removed)...
> > Hello folks,
> > I have a spreadsheet that has (in sheet 2) column H with a number of days
> > in
> > stock (1-60+) and the profit for that vehicle in column W. I want to add
> > all
> > the profit for the vehicles that are in stock between 31 and 45 days for
> > example. i.e. if column H is between 31 and 45 what is the corresponding
> > profit in column W. This then would enable me to calculate the
> > total/average
> > profit for any age band. The bands will be 1-30, 31-45, 46-60 and 61+.
> > Thank you in anticipation.
>
>
>