Hi,
I have a large log between 2012 & 2013 & soon into 2014.
I attempted to use the following functions, but neither is giving desires results. Do these functions not read dates?
=COUNT($C$16:$C$10000,"*2013*")
=COUNTIFS($C$16:$C$10000,"*2013*")
=SUMIF($C$16:$C$10000,"*2012*",$C$16:$C$10000)
Please advise & even better provide a function.
Thanks
Bookmarks