Hello Steve, changing H2 to =sum(if(isnumber(B$2:B$300);(B$2:B$300)*($D$2:$D$300=$F2);0)) or something along those lines works.
Regards Soeren Am 22.03.2012 17:30, schrieb greigsteve:
I would like to be able to use a sum array formula but still be able to put text in some of the cells in the column to be summed. I have attached a file with a simplified example of what I am trying to do. Hope you can help, http://old.nabble.com/file/p33544632/Ignore_text_array_formula.gnumeric Ignore_text_array_formula.gnumeric Steve
_______________________________________________ gnumeric-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/gnumeric-list
