DCOUNT Not working???

[TheNissanMan]

Any Excel Guru's out there as I am trying to use DCOUNT for the first time but it's not working?

The forumla I have entered is:

=DCOUNT('Cust Details'!J2:R61,9,DCOUNT!A1:B2)

From looking online it appears correct but it is not correcting the Y's in Column 9...

Any idea's?

 

[Jakey_Boy]

Any Excel Guru's out there as I am trying to use DCOUNT for the first time but it's not working?

The forumla I have entered is:

=DCOUNT('Cust Details'!J2:R61,9,DCOUNT!A1:B2)

From looking online it appears correct but it is not correcting the Y's in Column 9...

Any idea's?

Hi

Assuming you're looking to count the number of Ys in column 9 I would use the following:

= DCOUNT('Cust Details'!J2:R61,9,"Y")

Hope this helps

Jake

 

[TheNissanMan]

Thanks jake, counting the instances where both Geoff appear in the sales exec column with Y in the shown column.

 

[Jakey_Boy]

OK - got you now.

Assuming you are using Excel 2007 or greater then use the countifs() function.

If the Forename is in column A and the "Y"s are in column G say then use:

=countifs(A2:A100,"Geoff", G2:G100,"Y")

To make this more elegant I would define named ranges for Forename and Response and then use

=countifs(Forename,"Geoff", Response,"Y")

Jake

 

[Deleted member 49549]

In older versions of excel you can use sumproduct to do multiple if's in a countif

something like
=SUMPRODUCT((A2:A100="Geoff")*(G2:G100="Y"))
Or using named ranges
=SUMPRODUCT((Forename="Geoff")*(Response="Y"))

 

[f1charlie]

If you have it available the COUNTIFS function is the easiest as suggested above.

Otherwise try the DCOUNTA function as this counts the non-blank cells in the specified field where the criteria is met; DCOUNT counts cells which contain numbers and the criteria are met.

 

[TheNissanMan]

Thanks guys, I tried all of the above, couldn't get it to work so cheated. Used counting but rather than y put the sales guy number lol...

Many thanks for your attempts to help an excel dimwit.

 

[f1charlie]

Never admit defeat!

Provide a sample of data, replacing any sensitive data with dummy data and I'm sure we can sort it out for you. You never know when you might need to do it again so it might come in handy if you know how!