On Jun 18, 3:54 pm, Dave wrote:
Hi,
"Column B are the numbers I wish to Match"
What do you want to match the numbers in Column B to?
What is column C telling us?
Regards - Dave.

Sorry about that I should have explained a little further

Column B represents two like numbers in column A if column B shows a
pair then I hope to get a sum product of the remaining 2 digits in
column A if it does not then I hope to get “0”
Column C would be the formula result
I have also tried to break my 4 digit numbers in column A into 4
columns and also columns F and G into 4 Columns and enter a sum
product formula without success
Column F are the pairs 00 to 99 and will always remain the same Column
G will change daily or weekly with other 2 digit numbers

I might be digging myself into a hole here basically what I am trying
to do is return a value in a cell that would match the numbers in my
group in columns F and G
Example 0042 or 2004 would = 4 if using 4 columns or 2 if there is a
way to count just the numbers next to column F in column G even if I
split column G into two Columns