I think that you want

=IF(ISNUMBER(MATCH("VOID",'Cheque Register'!E$2:E$195)),"VOID",
SUMIF('Cheque Register'!A$2:A$195,B47,'Cheque Register'!C$2:C$195))

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"shaunap" wrote in message
...
Hi there,

I'm having an issue with a formula of mine. My data is 5 columns wide. I
have the formula listed below to retrieve the value of column C if column
A
matches a set value. Unless column E states "VOID". Then I want the value
input to be "Void". The formula kinda works. It gets the value of column
C
if column E is not void, but if column E states void then I get a 0.
Column
E is a formula in itself looking at column D for a value of 1. I tried
changing the formula below to search column D instead of E for a 1 instead
of
a void and then it returns the value of column C regardless of what it
finds.

{=SUM(IF('Cheque Register'!A$2:A$195=B47,IF('Cheque
Register'!E$2:E$195="VOID","VOID",'Cheque Register'!C$2:C$195),0))}

I'm not sure what I'm missing, the logic seems clear to me, but obviously
the computer thinks otherwise. If anybody out there can help me I'd
appreciate it.

Thanks,
Shauna