| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
#n/a
Can someone please tell me why the following formula is returning #n/a?
=SUMPRODUCT(--($J$12:$J$1000 =2),--($A$12:$A$1000 ="1"),($K$12:$K$1000)) Thanks for your time and help, Steve |
|
#2
|
|||
|
|||
|
Nevermind...It has magically started working.
"Steve" wrote: Can someone please tell me why the following formula is returning #n/a? =SUMPRODUCT(--($J$12:$J$1000 =2),--($A$12:$A$1000 ="1"),($K$12:$K$1000)) Thanks for your time and help, Steve |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
