dgorissen / pycel

A library for compiling excel spreadsheets to python code & visualizing them as a graph
GNU General Public License v3.0
573 stars 152 forks source link

COUNTIF and COUNTIFS #78

Closed tactycHQ closed 5 years ago

tactycHQ commented 5 years ago

If a range containing an empty cell or cells were to be passed to either COUNT or COUNTIF, I get a TypeError as follows:

TypeError: unorderable types: int() >= NoneType()

stephenrauch commented 5 years ago

Thanks for reporting this. I have been able to duplicate it, and should have a fix before too long.