dcount or and

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » DCount, Or, And

DCount, Or, And

resolvedResolved · Low Priority · Version 2003

Kirstine has attended:
Excel Advanced course

DCount, Or, And

Hello

Is it possible to combine DCOUNT in a formula with OR and AND?

RE: DCount, Or, And

Dear Kirstine

Thank you for attending Excel Advanced Course. I hope you enjoyed the course and benefited from it.

Normally you

RE: DCount, Or, And

Hi Rajeev

Many thanks for your reply. I would appreciate some examples. What I am trying to do is count rows where specific entries are, for example count as one if the salesperson is John, the product is apples and the county is hampshire.

Thanks again
Kirstine

RE: DCount, Or, And

Dear Kristine

Thank you for your response.


Please find attached excel file where I have done a simple DCOUNTA function to get the result that you are looking for!!

I have marked the various sections as database, Criteria Range and The Result for your convenience.

If you notice on cell E18 I have input the DCOUNTA function as below:

=DCOUNTA(A4:C15,C4,A1:C2)

I hope you understand the function and you can try to replace the data of your choice to see if that works for you!!

I hope this helps.

Many thanks

Kindest Regards

Rajeev Rawat
MOS Master Instructor 2000/2003
MCAS Master Instructor 2007

Attached files...

DCOUNTA.xls


 

Excel tip:

DATEDIF function

The DATEDIF function is a worksheet function that computes the difference between two dates. This function is documented only in the help files for Excel 2000. It isn't documented in Excel 2002.
the formula function is:
=DATEDIF(Your age,Today(),"Y")
Y stands for year

View all Excel hints and tips


Server loaded in 0.1 secs.