SumIf?

Originally Posted by Longover

I need help on a something that I just came across today. I need to be able to match a "name" with a "number". That is to say that I record the amount of times that a number occurs for a specific name. This might be easier to understand(pseudo):
(35 names X 6 different issues)
IF a cell range equals "TOM"
AND the cell adjacent to it equals "2"
THEN add 1 to this cell

Would i use sumif, or am i going in completely the wrong direction?

Hi,

try

=SUMPRODUCT(--(A$1:A$10=A1),--(B$1:B$10=B1))

with your names list and your numbers list as required. The formula is set to Fill the whole range of rows, and count the items shown on the row, the Red items can be changed to find a single occurrance.

hth
---