Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUMPRODUCT not returning TEXT value
Hi All....
All12! column K contains TEXT, like A+ This formula works fine if I use a different column than K which contains numbers but will not return the A+ value from column K......returns #VALUE! instead. =SUMPRODUCT((All12!$A$12:$A$15000=DATA!$A$1)*(All1 2!$Q$12:$Q$15000=DATA!$K$2)*(All12!$K$12:$K$15000) ) Is there a way to return TEXT values from column K if values in A and Q meet the criteria? TIA Vaya con Dios, Chuck, CABGx3 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct not returning data | Excel Worksheet Functions | |||
SUMPRODUCT returning no answer | Excel Worksheet Functions | |||
Help on sumproduct returning errors | Excel Worksheet Functions | |||
sumproduct returning #NA | Excel Discussion (Misc queries) | |||
Sumproduct returning #NUM! | Excel Worksheet Functions |