Thread: How do I select on two variables in a range of data in excel
View Single Post
  #4   Report Post  
D Hilberg
 
Posts: n/a
Default
=SUMPRODUCT((a1:a99="Bob")*(c1:c99="pending")*(b1: b99))

but use your own row ranges, of course.

- DH

Reply With QuoteReply With Quote