CountIf Formula Help (2003)
Thank You. works well
"T. Valko" wrote:
If you're using Excel 2003 then you can't use entire columns as range
references with this function.
Use cells to hold your criteria:
A1 = path repair
B1 = Concrete
C1 = Path Repair False
=SUMPRODUCT(--(N1:N100=A1),--(U1:U100=B1),--(Z1:Z100=C1))
--
Biff
Microsoft Excel MVP
"cayang68" wrote in message
...
I have been trying to work a formula to count cells based on certain
requirements. I am not sure if CountIf is the right formula to use....
I have named the following colums.
N:N = Department
U:U = Feature
Z:Z = Calculation
The formula I am trying to do is
If Feature = path repair and Department = Concrete then count Calculation
if
it = Path Repair False.
All the formulas I have tried to date have given me an error or an
incorrect
figure.
I hope someone can help.
Thanks
|