Is this a bug in Excel?

[D-niss]

From the Excel Help File


As per my previous post, I tested this - got the same answer as your UDF but no errors. I still want to understand why its throwing an error though, so will keep investigating.

lol you completly lost me there. Do you mean the subtotal function or the sumif function? I can't use subtotal cause it has to be part of a filter. That would require to much change to my template.

Worst to worst I'll write a proc that calculates those cells upon a Worksheet_calculate event.