A Count of Values in other Sheet

[jmueller0823]

Please see attached.

I need a count of sheet 'Schedule' Column B cell values that have a match in sheet 'Actions' Column G.

For example:

2.1 = 2-matches
2.3 = 1-match
2.8 = 1-match
3 = 2-matches

* * *

Then, I want the counts above to display in 'Schedule' Column O.

Thank you !

[FDibbins]

You can use COUNTIF() for this, but note that you have real numbers in Actions, but text looking like numbers in Schedule. Remove the "" from around the numbers and you should be good to go.
eg
IF(prevWBS="","1",
IF(prevWBS="",1,

[FDibbins]

Is this teh duplicate of your other thread here?
https://www.excelforum.com/excel-for...ml#post5163398

[jmueller0823]

Not a duplicate. The original topic had evolved to where it was no longer relevant.

[jmueller0823]

You can use COUNTIF() for this, but note that you have real numbers in Actions, but text looking like numbers in Schedule. Remove the "" from around the numbers and you should be good to go.
eg
IF(prevWBS="","1",
IF(prevWBS="",1,

So, I did not write that WBS formula, but it looks numeric to me (there are calculations made on that cell). What am I missing?
"Remove the "" from around the numbers" I'm not sure what you mean, please elaborate.

[AliGW]

Ford showed you what to do.

IF(prevWBS="","1",

returns 1 as text.

IF(prevWBS="",1,

returns 1 as a number.

[jmueller0823]

Here's the confusuon:

What does 'prevWBS' refer to?

And if we need these as numeric values. why convert a number to text?

Thanks again.

[AliGW]

It refers to Actions!B8.

Go to Formulas > Name Manager and you will see a list of all named ranges.

As for the answer to your second question, I can't find the IF formula in the workbook, so I can't check.

[jmueller0823]

My bad. Found it. Okay, so I removed the quotes from the 1 ... and still no count.

So, to simplify, I made a test without the WBS forumula. Please see attached sheet 'Actions' R42 ...

What am I miaaing? Appreciatre your time, thanks.

[FDibbins]

Actions R42 is empty.
Can you look again and see where we are supposed to be looking?

[jmueller0823]

Sorry, should be Actions B42 ... and the test count is in O42. Thanks much.

[Fluff13]

You've got the formula the wrong way round, it should be

Please Login or Register  to view this content.

[jmueller0823]

Thank yoiu!

[FDibbins]

Thanks for the feedback

[Fluff13]

You're welcome & thanks for the feedback