Thread: help with formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Brian Brian is offline
external usenet poster
  
Posts: 683
Default help with formula
=SUMPRODUCT(--(Sheet1!B2:B200="D"),--(Sheet1!C2:C200=4),D2:D200)

When I use this formula, the result is 0.

A B C D

1 D 4 2
2 B 2 3
3 D 5 5
4 A 2 2
Reply With QuoteReply With Quote