Re: Ignore text in array formula



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



[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]