Hi

Try this:

=SUMPRODUCT(--(A1:A6="mary"),--(D1:D6="specific"),B1:B6+C1:C6)


If this helps please check the yes button.
--
Thanks,
Shane Devenshire


"nursemlb" wrote:

Column a
Column b
Column c
Column d

If column d = "specific" and column a = "mary", would like to add columns b
and c

Please help!