View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
KB KB is offline
external usenet poster
 
Posts: 41
Default Sumif criteria "equal"

Hello, I want to search column A, if the values in column A are equal, I
want to sum the corresponding values in column D. I've tried the following
formula and it does not work:

=SUMIF(A5:A100,"=",D5:D100)

Could someone offer a suggestion for the correct "criteria" value?

Thanks