| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
why do i get #value! using this formula
can someone let me know why this formula is not working?
=SUMPRODUCT(--('Budget Dec 07'!A3:A19=Report!B9),--('Budget Dec 07'!I1:T1=6),'Budget Dec 07'!I3:T19) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
why do i get #value! using this formula
the arrays are not the same size
(17,12,17) in sumproduct each array must have the same number off items "Naraine Ramkirath" wrote: can someone let me know why this formula is not working? =SUMPRODUCT(--('Budget Dec 07'!A3:A19=Report!B9),--('Budget Dec 07'!I1:T1=6),'Budget Dec 07'!I3:T19) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
why do i get #value! using this formula
thanks for the clarification.
"bj" wrote in message ... the arrays are not the same size (17,12,17) in sumproduct each array must have the same number off items "Naraine Ramkirath" wrote: can someone let me know why this formula is not working? =SUMPRODUCT(--('Budget Dec 07'!A3:A19=Report!B9),--('Budget Dec 07'!I1:T1=6),'Budget Dec 07'!I3:T19) |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
why do i get #value! using this formula
"Naraine Ramkirath" wrote...
can someone let me know why this formula is not working? =SUMPRODUCT(--('Budget Dec 07'!A3:A19=Report!B9), --('Budget Dec 07'!I1:T1=6),'Budget Dec 07'!I3:T19) You have 17-by-1, 1-by-12 and 17-by-12 ranges, so you need to make the first two into a single array expression. Rearranging the terms, try =SUMPRODUCT('Budget Dec 07'!I3:T19, ('Budget Dec 07'!A3:A19=Report!B9)*('Budget Dec 07'!I1:T1=6)) |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
why do i get #value! using this formula
Harlan,
this formula evaluates to zero. could there be a bracket missing? "Harlan Grove" wrote in message oups.com... "Naraine Ramkirath" wrote... can someone let me know why this formula is not working? =SUMPRODUCT(--('Budget Dec 07'!A3:A19=Report!B9), --('Budget Dec 07'!I1:T1=6),'Budget Dec 07'!I3:T19) You have 17-by-1, 1-by-12 and 17-by-12 ranges, so you need to make the first two into a single array expression. Rearranging the terms, try =SUMPRODUCT('Budget Dec 07'!I3:T19, ('Budget Dec 07'!A3:A19=Report!B9)*('Budget Dec 07'!I1:T1=6)) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
