Dcounta criteria question

[excel-wizard-in-training]

Hi, I'm in search of some help with the criteria in my DCOUNTA formula. I've got the basic ones to work fine, but I'm trying to do some data validation with this last one, and it's got me stumped.

I think there are a number of ways to address it, but I think if I can resolve the issue below, I can overcome the obstacle I'm facing.

The fundamental issue I have is that I'm trying to count rows where the criteria uses a DOES NOT EQUAL symbol.

i.e. Criteria is ="<>UNASSESSED" to count anything that is not "UNASSESSED".

This doesn't seem to work though so I'm guessing my "s and <>s are not exactly right - or this isn't possible in a dcounta command.

Note: this is being used alongside 3 other criteria if that makes a difference - and although I could count all the non-UNASSESSEDs individually, there are a few too many to make it efficient. I've got this working using a SUM(IF( statement, but the amount of data is prohibiting the use of SUMIFs in the workbook.

Please help!

 

[texasalynn]

Welcome to MrExcel Board....

does this work?

Excel Workbook
	A	B	C	D	E	F
1	Type	Audit		Type	Audit
2		Assessed			<>UNASSESSED	2
3		Not Assessed
4		Unassessed
43
Sheet3

Excel 2003

Cell Formulas
Range	Formula
F2	=DCOUNTA(A1:B59,B1,D1:E2)

 

[excel-wizard-in-training]

Hi,

Thanks for the reply. As is often the way I seemd to have it working now. The two arguments I was having trouble with were:

Criteria 3:
="<>UNASSESSED" (everything but UNASSESSED)

and Criteria 4:
="<>" (All non-blanks)

It seems to be working fine now - but thanks for the speedy response.