Ineed to establish the correct formula for the SUMIF. I have enabled (1) vertical, or same horizontal, but I need to cover block label 1-100 sequence of top to bottom, left to right when changing the value cell #. I must not have a (),", =, +, entered somewhere?

OK. I've stared at this post and revisited several times over the last few days. I feel you deserve an answer, but I'm afraid you haven't asked a question which I can understand. I presume you want to know about SUMIF, and so thats what I'll tell you. Post back if you meant something else. SUMIF will analyse a set of data, returning a total of data which matches particular criteria. So: A | B x | 3 y | 2 z | 20 y | 1 z | 5 Say you want to add up all values from column B where column A contains a "z", the formula you'd use would be: =SUMIF(A1:A5,"z",B1:B5) and the answer would be 25 A1:A5 is the range of cells to compare "z" is the value you are comparing them to B1:B5 is the range of cells containing the values to SUM (This can work horizontally as well as vertically) I hope thats what you were asking...? Tom