This problem is killing me i know there must be a way to do what i am about to ask.
I am trying to have one cell (F27) search to see if cells (D9:D26) contain any of these acronyms (CE,CC,CD,CB) and if (D9:D26) do contain any of these acronyms then take the numeric value from (F9:F26) and place the sum in (F27). If (D9:D26) do not have any of these acronyms then i want (F27) to remain blank.
Thanks for any and all assistance given.
KittyF
I am trying to have one cell (F27) search to see if cells (D9:D26) contain any of these acronyms (CE,CC,CD,CB) and if (D9:D26) do contain any of these acronyms then take the numeric value from (F9:F26) and place the sum in (F27). If (D9:D26) do not have any of these acronyms then i want (F27) to remain blank.
Thanks for any and all assistance given.
KittyF