Thread: "Conditional" sum
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
davor davor is offline
external usenet poster
  
Posts: 2
Default "Conditional" sum
On 10 list, 14:51, "Sebation" wrote:
try:
=SUMPRODUCT((A1:C1="AA")*A2:C4)

HTH
Sebation.G

Thank you, that is IT!!!
Thank you alot!

Reply With QuoteReply With Quote