countif using 2 variables

[mccardled]

Hi,
I have read in the forum that this can usually be done using sumproduct, but can't work out how to do this using names and values.

I have names in column A, and values in column B, C, D... I want to count how many times a value occurs for a given name for each column.

Thanks,

[daddylonglegs]

It's a little more difficult to do because you have error values in the name range but try this formula in C45 copied across and down to D52

=SUMPRODUCT(--ISNUMBER(MATCH($A$3:$A$42,$A45,0)),--ISNUMBER(C$3:C$42))

[snasui]

Hi,
I have read in the forum that this can usually be done using sumproduct, but can't work out how to do this using names and values.

I have names in column A, and values in column B, C, D... I want to count how many times a value occurs for a given name for each column.

Thanks,

Try this:

C57
=COUNT(IF($A$3:$A$42=$A57,IF(C$3:C$42<>"",1)))

Ctrl+Shift+Enter and copy across then down.

Hope this helps.