Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula error
This formula works:
=SUMPRODUCT(--(Data!$L$7:$L$9998='Monthly Summary'!A18),--(Data!$AE$7:$AE$9998='Monthly Summary'!$C$1)) I wanted to add one more condition and wrote the below based on that: =SUMPRODUCT(--(Data!$L$7:$L$9998='Monthly Summary'!A35),--(Data!AE7:AE9998='Monthly Summary'!$C$1),--(Data!K7:K9999='Monthly Summary'!A13)) The working formula is great. Where did my sintax go wrong or what is happening to give me a value error? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula error
The last array isn't the same size:
Data!$L$7:$L$9998 Data!AE7:AE9998 Data!K7:K9999 -- Biff Microsoft Excel MVP "Jeremy" <jeremiah.a.reynolds @ gmail.com wrote in message ... This formula works: =SUMPRODUCT(--(Data!$L$7:$L$9998='Monthly Summary'!A18),--(Data!$AE$7:$AE$9998='Monthly Summary'!$C$1)) I wanted to add one more condition and wrote the below based on that: =SUMPRODUCT(--(Data!$L$7:$L$9998='Monthly Summary'!A35),--(Data!AE7:AE9998='Monthly Summary'!$C$1),--(Data!K7:K9999='Monthly Summary'!A13)) The working formula is great. Where did my sintax go wrong or what is happening to give me a value error? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Error | New Users to Excel | |||
formula error | Excel Worksheet Functions | |||
How do I replace "#N/A" error, to continue my formula w/o error? | Excel Worksheet Functions | |||
Formula Error | New Users to Excel | |||
Formula Error | Excel Discussion (Misc queries) |