SUMIF INDIRECT
 

Hi

Can anyone tell me how to sum a range of numbers in column D, provided that
adjacent cells in row A contain "Apples" and row C contain "Oranges".

Thanks
Alec

SUMIF INDIRECT
 

=SUMPRODUCT(--(A2:A200="Apples"),--(C2:C200="Oranges"),D2:D200)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Alectrical" wrote in message
...
Hi

Can anyone tell me how to sum a range of numbers in column D, provided
that
adjacent cells in row A contain "Apples" and row C contain "Oranges".

Thanks
Alec

SUMIF INDIRECT
 

Hi

Try something like this:

=SUMPRODUCT((A2:A1000="Apples")*(C2:C1000="Oranges ")*(D2:D1000))

When using Sumproduct, make sure that the ranges are all the same size and
are not full columns.

Hope this helps.
Andy.

"Alectrical" wrote in message
...
Hi

Can anyone tell me how to sum a range of numbers in column D, provided
that
adjacent cells in row A contain "Apples" and row C contain "Oranges".

Thanks
Alec

SUMIF INDIRECT
 

Thanks Bob

"Bob Phillips" wrote:

=SUMPRODUCT(--(A2:A200="Apples"),--(C2:C200="Oranges"),D2:D200)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Alectrical" wrote in message
...
Hi

Can anyone tell me how to sum a range of numbers in column D, provided
that
adjacent cells in row A contain "Apples" and row C contain "Oranges".

Thanks
Alec

SUMIF INDIRECT
 

Thanks Andy, your function works on a new sheet, but when I type the
following function into an existing sheet I get the #VALUE message. Any ideas.

=SUMPRODUCT((A13:A6000="IO")*(F13:F6000="2PLC")*(H 13:H6000))

"Andy" wrote:

Hi

Try something like this:

=SUMPRODUCT((A2:A1000="Apples")*(C2:C1000="Oranges ")*(D2:D1000))

When using Sumproduct, make sure that the ranges are all the same size and
are not full columns.

Hope this helps.
Andy.

"Alectrical" wrote in message
...
Hi

Can anyone tell me how to sum a range of numbers in column D, provided
that
adjacent cells in row A contain "Apples" and row C contain "Oranges".

Thanks
Alec

SUMIF INDIRECT
 

Do you have text in H13:H6000? IF so, correct it or use my format.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Alectrical" wrote in message
...
Thanks Andy, your function works on a new sheet, but when I type the
following function into an existing sheet I get the #VALUE message. Any
ideas.

=SUMPRODUCT((A13:A6000="IO")*(F13:F6000="2PLC")*(H 13:H6000))

"Andy" wrote:

Hi

Try something like this:

=SUMPRODUCT((A2:A1000="Apples")*(C2:C1000="Oranges ")*(D2:D1000))

When using Sumproduct, make sure that the ranges are all the same size
and
are not full columns.

Hope this helps.
Andy.

"Alectrical" wrote in message
...
Hi

Can anyone tell me how to sum a range of numbers in column D, provided
that
adjacent cells in row A contain "Apples" and row C contain "Oranges".

Thanks
Alec

SUMIF INDIRECT
 

Hi

You must have a text value in your H range.

Andy.

"Alectrical" wrote in message
...
Thanks Andy, your function works on a new sheet, but when I type the
following function into an existing sheet I get the #VALUE message. Any
ideas.

=SUMPRODUCT((A13:A6000="IO")*(F13:F6000="2PLC")*(H 13:H6000))

"Andy" wrote:

Hi

Try something like this:

=SUMPRODUCT((A2:A1000="Apples")*(C2:C1000="Oranges ")*(D2:D1000))

When using Sumproduct, make sure that the ranges are all the same size
and
are not full columns.

Hope this helps.
Andy.

"Alectrical" wrote in message
...
Hi

Can anyone tell me how to sum a range of numbers in column D, provided
that
adjacent cells in row A contain "Apples" and row C contain "Oranges".

Thanks
Alec

SUMIF INDIRECT
 

Thanks Bob, you've been very helpful



"Bob Phillips" wrote:

Do you have text in H13:H6000? IF so, correct it or use my format.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Alectrical" wrote in message
...
Thanks Andy, your function works on a new sheet, but when I type the
following function into an existing sheet I get the #VALUE message. Any
ideas.

=SUMPRODUCT((A13:A6000="IO")*(F13:F6000="2PLC")*(H 13:H6000))

"Andy" wrote:

Hi

Try something like this:

=SUMPRODUCT((A2:A1000="Apples")*(C2:C1000="Oranges ")*(D2:D1000))

When using Sumproduct, make sure that the ranges are all the same size
and
are not full columns.

Hope this helps.
Andy.

"Alectrical" wrote in message
...
Hi

Can anyone tell me how to sum a range of numbers in column D, provided
that
adjacent cells in row A contain "Apples" and row C contain "Oranges".

Thanks
Alec

SUMIF INDIRECT
 

Thanks again Andy, you've been very helpful


"Andy" wrote:

Hi

You must have a text value in your H range.

Andy.

"Alectrical" wrote in message
...
Thanks Andy, your function works on a new sheet, but when I type the
following function into an existing sheet I get the #VALUE message. Any
ideas.

=SUMPRODUCT((A13:A6000="IO")*(F13:F6000="2PLC")*(H 13:H6000))

"Andy" wrote:

Hi

Try something like this:

=SUMPRODUCT((A2:A1000="Apples")*(C2:C1000="Oranges ")*(D2:D1000))

When using Sumproduct, make sure that the ranges are all the same size
and
are not full columns.

Hope this helps.
Andy.

"Alectrical" wrote in message
...
Hi

Can anyone tell me how to sum a range of numbers in column D, provided
that
adjacent cells in row A contain "Apples" and row C contain "Oranges".

Thanks
Alec