Sumproduct /And
 

I hope this is answered elsewhere I couldn't find anything relevant.

I want to sum a column where 2 conditions are met. I have tried the
following formula but can't seem to get it to work.

=Sumproduct(--And(Sheet2!$A$1:$A$300=A2,Sheet2!$B$1:$B$300="Accr ual")*Sheet2!$C$1:$C$300)

I am sure I have used a similar formula before but can't remember where.

Thanks
Rick

Sumproduct /And
 

Try

=SUMPRODUCT(--(Sheet2!$A$1:$A$300=A2),--(Sheet2!$B$1:$B$300="Accrual"),--(Sheet2!$C$1:$C$300))

If this post helps click Yes
---------------
Jacob Skaria


"Rick" wrote:

I hope this is answered elsewhere I couldn't find anything relevant.

I want to sum a column where 2 conditions are met. I have tried the
following formula but can't seem to get it to work.

=Sumproduct(--And(Sheet2!$A$1:$A$300=A2,Sheet2!$B$1:$B$300="Accr ual")*Sheet2!$C$1:$C$300)

I am sure I have used a similar formula before but can't remember where.

Thanks
Rick

Sumproduct /And
 

=SUMPRODUCT(--(Sheet2!$A$1:$A$300=A2),--(Sheet2!$B$1:$B$300="Accrual"),--(Sheet2!$C$1:$C$300))

No need for the double unary -- on the last array:

=SUMPRODUCT(--(Sheet2!$A$1:$A$300=A2),--(Sheet2!$B$1:$B$300="Accrual"),Sheet2!$C$1:$C$300)

--
Biff
Microsoft Excel MVP


"Jacob Skaria" wrote in message
...
Try

=SUMPRODUCT(--(Sheet2!$A$1:$A$300=A2),--(Sheet2!$B$1:$B$300="Accrual"),--(Sheet2!$C$1:$C$300))

If this post helps click Yes
---------------
Jacob Skaria


"Rick" wrote:

I hope this is answered elsewhere I couldn't find anything relevant.

I want to sum a column where 2 conditions are met. I have tried the
following formula but can't seem to get it to work.

=Sumproduct(--And(Sheet2!$A$1:$A$300=A2,Sheet2!$B$1:$B$300="Accr ual")*Sheet2!$C$1:$C$300)

I am sure I have used a similar formula before but can't remember where.

Thanks
Rick

Sumproduct /And
 

Hi,

In 2007 you can also use:

SUMIFS(Sheet2!C$1:C$300,Sheet2!A$1:A$300,A2,Sheet2 !B$1:B$300,"Accrual"

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Rick" wrote:

I hope this is answered elsewhere I couldn't find anything relevant.

I want to sum a column where 2 conditions are met. I have tried the
following formula but can't seem to get it to work.

=Sumproduct(--And(Sheet2!$A$1:$A$300=A2,Sheet2!$B$1:$B$300="Accr ual")*Sheet2!$C$1:$C$300)

I am sure I have used a similar formula before but can't remember where.

Thanks
Rick