CONDITIONAL SUM FOR MULTIPLE CRITERIA IN SINGLE RANGE

strinnes · Sep 17, 2013

Hi! I want to sum column B (Count) if column A (State) equals "NY" and "VA" to give a sum of 12.

Thanks in advance to all responses!

)

STATE COUNT
NY 5
TX 10
VA 7

isabelle · Sep 17, 2013

hi,

=SUMPRODUCT(($A$2:$A$4="NY")+($A$2:$A$4="VA"),($B$2:$B$4))

isabelle

Le 2013-09-16 19:45, [email protected] a écrit :