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?

E11111111	1
E11111111	2
E11111111	3
E11111111	4
E22222222	1
E22222222	2
E33333333	1

<tbody>
</tbody>

if so try this

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

 

[bflan0524]

Is this what your data looks like?

E11111111	1
E11111111	2
E11111111	3
E11111111	4
E22222222	1
E22222222	2
E33333333	1

<tbody>
</tbody>

if so try this

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

no it looks more like this

E00000000023	A000001234567
E00000000040	A000000234567
E00000000094	A000000034567
E00000000098	A000000005678

<colgroup><col><col></colgroup><tbody>
</tbody>

 

[bflan0524]

+