Calculating accurences in one column based on an accurence in another

[Josh1759]

Example: Column A in a spreadsheet has the # 8 appearing 200 times. Ctrl+F gives me the cells and the total amount of occurrences. However, I would like to find out in column B the same information on #15 but only the corresponding to the cell that contains the #8 in column A

[jeffreybrown]

Hello & Welcome to the Forum,

How about...

=COUNTIFS(A1:A32,8,B1:B32,15)

Adjust ranges as required

[Josh1759]

Hello & Welcome to the Forum,

How about...

=COUNTIFS(A1:A32,8,B1:B32,15)

Adjust ranges as required

Jeffry, Thank you very much. It works

[jeffreybrown]

You are very welcome. Glad it worked out for you and thanks for the feedback.

[Josh1759]

Jeffrey, Instead of manually changing 15, to 16 and etc,. for results on occurrences on column B. is there a way to to automate .The 8 should remain a constant. and is it possible to find out the occurrence in column B in a range of #s,(ie: 17 to 25)

[bebo021999]

Just replace 15 in Jeff's with the cell which contains criteria number
[EDIT] May be =COUNTIFS(A1:A32,8,B1:B32,">17",B1:B32,"<25")

[Josh1759]

It works. Thank You

[Josh1759]

Hello
How would I copy or transfer cell A1 ie: 1-2-3-4-5-6-7-8-9-10 into 10 separate cells in in same corresponding Row without the -(Dashes)

[jeffreybrown]

Use text to columns with a "-" as a delimiter.

http://support.microsoft.com/kb/214261

Next time, please start a new thread when posing a new question.

[:) Sixthsense :)]

How would I copy or transfer cell A1 ie: 1-2-3-4-5-6-7-8-9-10 into 10 separate cells

In A1 cell
1-2-3-4-5-6-7-8-9-10

In B1 cell

Please Login or Register  to view this content.

Drag it to right...