I have a worksheet that has many conditional sum functions in it. The array
is exported data out of an accounting program. The formating is the same
between the criteria and the range however I can not seem to get it to work
when I export new data it just comes back with the answer of zero which is
incorrect. I have other worksheets with the same set up except one of the
criteria has letters and numbers in the criteria and they work fine. In the
worksheet that does not work that same criteria is just numbers. Can someone
help me with this issue?