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
|