|
|
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.
.
|