View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
cayang68 cayang68 is offline
external usenet poster
 
Posts: 4
Default CountIf Formula Help (2003)

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