Formula Suggestion Please?
 

Below is a formula I'm attempting to use, and post on my QA Data Sheet Tab.
The actual data is being pulled from my New Rules Client Tab, and while Excel
is accepting the formula in the applicable cell, the outcome value is not
correct (it registers 0, and I know that this is not an accurate outcome).

My requirements are the following:

If a client has completed their class as identified in Column (Y), but has
not yet had their final interview (Column Z), count that total (completed
class, but not had their final interview). I'd appreciate any formula
suggestions to remedy this problem.

Thank You

=SUMPRODUCT('New Rule Clients'!Y4:Y3500="Yes")*(Z4:Z3500="")

Formula Suggestion Please?
 

You've missed a pair of brackets - try this:

=SUMPRODUCT(('New Rule Clients'!Y4:Y3500="Yes")*(Z4:Z3500=""))

Hope this helps.

Pete

On Jul 10, 11:08 pm, Dan the Man
wrote:
Below is a formula I'm attempting to use, and post on my QA Data Sheet Tab.
The actual data is being pulled from my New Rules Client Tab, and while Excel
is accepting the formula in the applicable cell, the outcome value is not
correct (it registers 0, and I know that this is not an accurate outcome).

My requirements are the following:

If a client has completed their class as identified in Column (Y), but has
not yet had their final interview (Column Z), count that total (completed
class, but not had their final interview). I'd appreciate any formula
suggestions to remedy this problem.

Thank You

=SUMPRODUCT('New Rule Clients'!Y4:Y3500="Yes")*(Z4:Z3500="")

Formula Suggestion Please?
 

If both on the same sheet then you need to reference it again.
If a problem with "" try <"yes"

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Dan the Man" wrote in message
...
Below is a formula I'm attempting to use, and post on my QA Data Sheet
Tab.
The actual data is being pulled from my New Rules Client Tab, and while
Excel
is accepting the formula in the applicable cell, the outcome value is not
correct (it registers 0, and I know that this is not an accurate outcome).

My requirements are the following:

If a client has completed their class as identified in Column (Y), but has
not yet had their final interview (Column Z), count that total (completed
class, but not had their final interview). I'd appreciate any formula
suggestions to remedy this problem.

Thank You

=SUMPRODUCT('New Rule Clients'!Y4:Y3500="Yes")*(Z4:Z3500="")

Formula Suggestion Please?
 

You were very close:

=SUMPRODUCT(('New Rule Clients'!Y4:Y3500="Yes")*('New Rule
Clients'!Z4:Z3500=""))

Slightly more efficient:

=SUMPRODUCT(--('New Rule Clients'!Y4:Y3500="Yes"),--('New Rule
Clients'!Z4:Z3500=""))

--
Biff
Microsoft Excel MVP


"Dan the Man" wrote in message
...
Below is a formula I'm attempting to use, and post on my QA Data Sheet
Tab.
The actual data is being pulled from my New Rules Client Tab, and while
Excel
is accepting the formula in the applicable cell, the outcome value is not
correct (it registers 0, and I know that this is not an accurate outcome).

My requirements are the following:

If a client has completed their class as identified in Column (Y), but has
not yet had their final interview (Column Z), count that total (completed
class, but not had their final interview). I'd appreciate any formula
suggestions to remedy this problem.

Thank You

=SUMPRODUCT('New Rule Clients'!Y4:Y3500="Yes")*(Z4:Z3500="")

Formula Suggestion Please?
 

Thank you everyone.................Got it......What a great group!

Dan

"Pete_UK" wrote:

You've missed a pair of brackets - try this:

=SUMPRODUCT(('New Rule Clients'!Y4:Y3500="Yes")*(Z4:Z3500=""))

Hope this helps.

Pete

On Jul 10, 11:08 pm, Dan the Man
wrote:
Below is a formula I'm attempting to use, and post on my QA Data Sheet Tab.
The actual data is being pulled from my New Rules Client Tab, and while Excel
is accepting the formula in the applicable cell, the outcome value is not
correct (it registers 0, and I know that this is not an accurate outcome).

My requirements are the following:

If a client has completed their class as identified in Column (Y), but has
not yet had their final interview (Column Z), count that total (completed
class, but not had their final interview). I'd appreciate any formula
suggestions to remedy this problem.

Thank You

=SUMPRODUCT('New Rule Clients'!Y4:Y3500="Yes")*(Z4:Z3500="")