This is close to what I'm looking for, however FIND(B16,B14:B17) does not
seem to work, it reurns #value. FIND(B16,B17) does work.

"Ashish Mathur" wrote:

Hi,

You may also try the following array formula (Ctrl+Shift+Enter). This is in
range B14:C17

b 1
n 2
m 3
a,m 4

=sum(C14:C17)-SUM(IF(ISNUMBER(FIND(B16,B14:B17)),C14:C17))

Regards,

"Father" wrote:

Hello I am trying to sum data in a column based on the absence of a character
in a related column.
That is to say I need to be able to exclude rows that contain an "m" (there
may be multiple characters in the criteria cell)
Anyone have any ideas?