# RE: Sumproduct /And

Jacob Skaria
Guest
Posts: n/a

 10th Jun 2009
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

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post Majken Bilslev-Jensen Microsoft Excel Programming 7 30th Dec 2010 06:56 PM gholly Microsoft Excel Misc 2 28th Sep 2009 05:07 PM Ted M H Microsoft Excel Worksheet Functions 4 14th Aug 2008 07:50 PM =?Utf-8?B?RGF2aWQ=?= Microsoft Excel Worksheet Functions 3 13th Jul 2007 07:06 PM =?Utf-8?B?TWFyaw==?= Microsoft Excel Programming 3 23rd Nov 2005 03:36 PM

Features