View Single Post
  #2   Report Post  
BobT
 
Posts: n/a
Default

You can use sumproduct
check out the link below
http://www.xldynamic.com/source/xld.SUMPRODUCT.html


-----Original Message-----
Hello, (Excel 2003)
Column A contains list of buildings (25+ building names,

1000+ rows)
Column D contains a letter indicating if work done ("c")
Column E contains text indicating work not done ("n/c")

I would like to count the "c"'s grouped by Building name

and in a separate
cell count the "n/c"'s grouped by Building name. I have

tried VLookup with
CountIf without any luck.
--
Thank-you and all suggestions are appreciated.
.