antrat
asked on
using the countif function
when using the countif formula how do I set 2 criteria
eg countif(A1:A800,">B1","<B2 "). The data in cells B1 & B2 are dates.
[Cancel Editing]
[How To Use Experts Exchange]
[Home]
Copyrights © 1996-1998 Experts Exchange, Inc. - Patent Pending
eg countif(A1:A800,">B1","<B2
[Cancel Editing]
[How To Use Experts Exchange]
[Home]
Copyrights © 1996-1998 Experts Exchange, Inc. - Patent Pending
ASKER
Edited text of question
You don't! It only alows for one criteria.
You will have to work around it.
Try using something like this (note the use of x to represent the value of the rows that should be unique for each row)
=IF((Ax>$B$1),Ax,0) in column C
=IF((Ax<$B$2),Ax,0) in column D
=IF(Cx=Dx,1,"") in column E and count the results in column E
Let me know if it is any help!!
You will have to work around it.
Try using something like this (note the use of x to represent the value of the rows that should be unique for each row)
=IF((Ax>$B$1),Ax,0) in column C
=IF((Ax<$B$2),Ax,0) in column D
=IF(Cx=Dx,1,"") in column E and count the results in column E
Let me know if it is any help!!
You'll probably have to use the DCount or DCountA functions that are provided
ASKER
I've been trying to use the DCOUNT & DCOUNTA functions
but they still don't accept 2 criteria , or maybe I'm not Writing
them properly . Could please give an example based on my
own example.
but they still don't accept 2 criteria , or maybe I'm not Writing
them properly . Could please give an example based on my
own example.
ASKER
Tried using the DCount & DCountA functions but they don't seem to accept 2 criteria either.
ASKER
Jboddy
Thanks for your answer. What you have suggested will
work unfortunatley I have something similar in my spreadsheet
now , and I wanted to change the formular to reduce the file size.
Thanks for your answer. What you have suggested will
work unfortunatley I have something similar in my spreadsheet
now , and I wanted to change the formular to reduce the file size.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER