ExcelBanter - # Value Error

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - # Value Error (https://www.excelbanter.com/excel-programming/423648-value-error.html)

=SUMPRODUCT(--($Y$36:$Y1948=$AD$19)*--($I$36:$I$1948),$I$36:$I$1948)
with this formula I am getting a #VALUE error,

what I am trying to do is..
look in column Y for a specific number ..say 6...that is corresponding
number in col AD row 19
and add the number ffrom col I in rows 36 thru 1948..to the existing value
in the cell as a sum

=SUMIF($Y$36:$Y1948,$AD$19,$I$36:$I$1948)

--
__________________________________
HTH

Bob

"Ken G" wrote in message
...
=SUMPRODUCT(--($Y$36:$Y1948=$AD$19)*--($I$36:$I$1948),$I$36:$I$1948)
with this formula I am getting a #VALUE error,

what I am trying to do is..
look in column Y for a specific number ..say 6...that is corresponding
number in col AD row 19
and add the number ffrom col I in rows 36 thru 1948..to the existing value
in the cell as a sum

It comes back error in formula...I used it your way...then I tried to put a
($) before 1948 in the first array and ($) before 1948 in the second
array..still doesnt work
do I need a ) after the first array..then a comma without a ( in the second
array

"Bob Phillips" wrote:

=SUMIF($Y$36:$Y1948,$AD$19,$I$36:$I$1948)

--
__________________________________
HTH

Bob

"Ken G" wrote in message
...
=SUMPRODUCT(--($Y$36:$Y1948=$AD$19)*--($I$36:$I$1948),$I$36:$I$1948)
with this formula I am getting a #VALUE error,

what I am trying to do is..
look in column Y for a specific number ..say 6...that is corresponding
number in col AD row 19
and add the number ffrom col I in rows 36 thru 1948..to the existing value
in the cell as a sum