What i am looking to do is, say i have three sections of a chart. In these sections there are numbers. Is it possible to use vlookup and have it go thru the three sections and count the number of times 0 is in the sections? Or would i need to use something else? Or is this possible. I just want a cell that will search these sections and give me a total of how many times 0 is there. I don't know if vlookup is what i need or maybe a sumif? Any ideas anyone? I have never used nor wrote any vlookups, so i don't really know what to do with that. I have only done simple sumifs also, so i don't really know how i would do that either. I'm not looking for a sum total, but a number of instances.
Thanks again guys!!! I do hate to keep bugging you guys with this stuff. I am trying before looking around for help.
Thanks a bunch.
Bookmarks