You're welcome!

--
Biff
Microsoft Excel MVP


"casey" wrote in message
...
Perfect! Next step for me is to break down what your formula and
understand
why.

Thanks a million!!!
casey

"casey" wrote:

Consider the following:

Col A Col B Col C Col D
ERDF 45,678 JKNM 23,234
JKNM 12,909 ABCD 54,567
ABCD 22,222 ERDF 11,111

I want to search every column for ERDF and sum the column to the right of
it. Consider enough columns to reach column BZ.

Thanks,
casey