assume (cell) means the value held in cell M9

=Sumproduct(--(A2:A50=$M$9),--(D3:D50="No"),B3:B50)

--
Regards,
Tom Ogilvy

"joi2" wrote in message
...

I need a little help does anyone know of a code that can add a cell if a
certain condition is true. For instance I attached a file to help
understand this a little better. If for instance cell a3 = (cell) and
cell d3 = (no) add whatever value is in cell b3. and do this every
time that case is true does anyone know how to do that?


+-------------------------------------------------------------------+
|Filename: jea.zip |
|Download: http://www.excelforum.com/attachment.php?postid=3948 |
+-------------------------------------------------------------------+

--
joi2
------------------------------------------------------------------------
joi2's Profile:
http://www.excelforum.com/member.php...o&userid=27554
View this thread: http://www.excelforum.com/showthread...hreadid=479172