RE: 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="Accrual")*Sheet2!$C$1:$C$300)
>
> I am sure I have used a similar formula before but can't remember where.
>
> Thanks
> Rick