Thread: "Conditional" sum
View Single Post
  #4  
Old October 10th, 2007, 02:02 PM posted to microsoft.public.excel.worksheet.functions
davor
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!