COUNTIFS Function

[bflan0524]

hello, need a formula for the following, i think its countifs but i keep messing up

column A has a list of Enterprise ID's for example E11111111
Column B has account numbers associated with Column A

so there could be 5 account numbers associated with column A for example or just one

on a separate sheet i took a list of all the enterprise IDs and i wanted to do a count on how many Account #s are associated with those ID's

i did put ==countifs('Locked Portfolio'!A:A,Sheet1!A1,'Locked Portfolio'!B:B)

not sure if that makes sense, locked portfolio is the name of the sheet i put all the unique enterprise IDs on

thanks

 

[Nine Zero]

Is this what your data looks like?

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]E11111111[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]E11111111[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]E11111111[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]E11111111[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]E22222222[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]E22222222[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]E33333333[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]

if so try this

=COUNTIF('Locked Portfolio'!A:A,Sheet1!A1)

 

[bflan0524]

Is this what your data looks like?

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]E11111111[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]E11111111[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]E11111111[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]E11111111[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]E22222222[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]E22222222[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]E33333333[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]

if so try this

=COUNTIF('Locked Portfolio'!A:A,Sheet1!A1)

no it looks more like this

[TABLE="width: 193"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]E00000000023 [/TD]
[TD]A000001234567[/TD]
[/TR]
[TR]
[TD]E00000000040[/TD]
[TD]A000000234567[/TD]
[/TR]
[TR]
[TD]E00000000094[/TD]
[TD]A000000034567[/TD]
[/TR]
[TR]
[TD]E00000000098[/TD]
[TD]A000000005678[/TD]
[/TR]
</tbody>[/TABLE]

 

[bflan0524]

+