Help PLEASE!!!!

[joi2]

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 |
+-------------------------------------------------------------------+

 

[Tom Ogilvy]

assume (cell) means the value held in cell M9

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

 

[Bob Phillips]

SUMPRODUCT must use similar sized ranges

=Sumproduct(--(A3:A50=$M$9),--(D350="No"),B3:B50)


--

HTH

RP
(remove nothere from the email address if mailing direct)

assume (cell) means the value held in cell M9

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

 

[Tom Ogilvy]

Yep, typo, thanks.

--
Regards,
Tom Ogilvy

SUMPRODUCT must use similar sized ranges

=Sumproduct(--(A3:A50=$M$9),--(D350="No"),B3:B50)


--

HTH

RP
(remove nothere from the email address if mailing direct)