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