# Value Error

K

Ken G

=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
 
K

Ken G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

show cell value 2
Column number of last column that returns value ignore formulas 8
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
List 6-of-36 combinations matching 4 (errata) 1
Formula error; was working 1
Copy a Cell with a macro 2
Formula for seasons in a multi-year worksheet 2
A For Each in Range... with a .Find(what:="TJ", ... in it problem 15

Top