Sumif criteria "equal"
If the cells are equal to what?
If you want to get a subtotal of each column A value, use a Pivot Table
(Data Pivot Table in Excel 2003) and drop your column A label into the row
field and column d in the Data field.
"KB" wrote:
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
|