Sumproduct not works
In below formula in place D1 it should come "B" but its not work why?
A B C D 1 A 2 =SUMPRODUCT(--($A$1:$A$5=C1),--$B$1:$B$5) 2 B 3 C 4 D 5 E |
Sumproduct not works
Because True (or 1) multipled by a letter is an invalid math operation.
Why not just do =LOOKUP(C1,$A$1:$B$5) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "kashish" wrote: In below formula in place D1 it should come "B" but its not work why? A B C D 1 A 2 =SUMPRODUCT(--($A$1:$A$5=C1),--$B$1:$B$5) 2 B 3 C 4 D 5 E |
All times are GMT +1. The time now is 09:54 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com