Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Simple Question Complicated Formula
I have a long formula that I'm trying to modify:
{=IF(OR(I3TODAY(),I3=""),"",SUMPRODUCT((Client_Da ta!$A$3:$A$4000<=$B3)*((Client_Data!$N$3:$N$4000=" ")+(Client_Data!$N$3:$N$4000=$B3))*(Client_Data!$ K$3:$K$4000=K$2)))} Row 2 includes headers and this formula pulls data from the Client_Data sheet which matches the K header. What I'm trying to do is to rewrite this formula so that it doesn't look at the header's text but can be any text found on the sheet. I'm looking for the wildcard character to say "any text found in matching cells". My guess is, "*", but when I enter the formula: {=IF(OR(I3TODAY(),I3=""),"",SUMPRODUCT((Client_Da ta!$A$3:$A$4000<=$B3)*((Client_Data!$N$3:$N$4000=" ")+(Client_Data!$N$3:$N$4000=$B3))*(Client_Data!$ K$3:$K$4000="*")))} It doesn't work the way it should. Can someone please help me exchange the K$2 entry please??? Seems simple but it's eluding me. Thanks in advance! --Dax -- I would give my left hand to be ambidextrous! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
simple formula question | Excel Discussion (Misc queries) | |||
IF formula-simple question; simple operator | Excel Discussion (Misc queries) | |||
Simple Formula Question | Excel Discussion (Misc queries) | |||
complicated sum formula question | Excel Worksheet Functions | |||
Simple, but Complicated | Excel Discussion (Misc queries) |