98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » DCount, Or, And
DCount, Or, And
Resolved · 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...
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:DATEDIF functionThe 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. |