Search and IF Function combo?

JBeaucaire, I've tried that but it doesn't seem to work, thanks for trying though it was my fault for a poor explanation :P


Okay, first off to hopefully aide understanding of the problem I've uploaded an image of a simplified version of my spreadsheet here: http://img28.imageshack.us/img28/7910/excelm.jpg


The problem is as follows:

For each of the 20 letters A-T, I need to do a search (in columns B and D). For each cell the desired letter is found, the row number should be used as a constant in another formula - where the cell in column F and column K (both with the same row) will return a value of 1 if they are equal and a value of 0 if they are not equal. This should be repeated for each time the specified letter is found and summed together.


I realise this probably sounds like rubbish, so using an example for the letter A:
Search for A in range B4:D13. Found in cell B6, so row 6 is constant. F$6 gives value N and K$6 gives value Y, so F$6 doesn't equal K$6, so return value is 0.
Search for A in second range B19:D28. Found in cell D21, so row 21 is constant. F$21 gives Y and K$21 gives Y, so return value is 1 since F$21 = K$21
Adding the two returned values together gives 0+1=1




This needs to be done for 38 different ranges for all 20 letters, so I'm sure you can appreciate how tedious it would be to calculate every value manually.. :P

Effectively I just need a search which can provide each row number for an IF function and an addition function to add the results of the IF function, but I don't know how to do it. And rather than searching for the letter in each range, would it be able to search for EVERY value of the letter throughout the whole of columns B and D and return the row numbers for all of them (38 different rows)?

Hopefully that the explanation makes sense, if anyone can help I would be grateful =]

Ah yes, having tried it again it does work, thanks very much =]