Formula2 needed, please.

[snd]

[TABLE="width: 467"]
<tbody>[TR]
[TD]srl#[/TD]
[TD]Month[/TD]
[TD]Voucher[/TD]
[TD]Source[/TD]
[TD]Amount[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Formula1
[/TD]
[TD]Formula2[/TD]
[/TR]
[TR]
[TD="align: right"]520[/TD]
[TD="align: right"]Sep-11[/TD]
[TD="align: right"]5003750[/TD]
[TD]Inventory[/TD]
[TD="align: right"](1.43)[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1114[/TD]
[TD="align: right"]Sep-11[/TD]
[TD="align: right"]5003750[/TD]
[TD]Inventory[/TD]
[TD="align: right"](15.73)[/TD]
[TD="align: right"](17.16)
[/TD]
[TD]Negative[/TD]
[/TR]
[TR]
[TD="align: right"]92[/TD]
[TD="align: right"]Oct-12[/TD]
[TD="align: right"]5005762[/TD]
[TD]Purchasing[/TD]
[TD="align: right"]1,778.00[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]93[/TD]
[TD="align: right"]Oct-12[/TD]
[TD="align: right"]5005762[/TD]
[TD]Purchasing[/TD]
[TD="align: right"]2,834.80[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]2872[/TD]
[TD="align: right"]Apr-14[/TD]
[TD="align: right"]5005762[/TD]
[TD]Inventory[/TD]
[TD](2,834.80)[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]91[/TD]
[TD="align: right"]Oct-12[/TD]
[TD="align: right"]5005762[/TD]
[TD]Purchasing[/TD]
[TD="align: right"]3,193.20[/TD]
[TD="align: right"]4,971.20
[/TD]
[TD]Mixed[/TD]
[/TR]
[TR]
[TD="align: right"]2871[/TD]
[TD="align: right"]Apr-14[/TD]
[TD="align: right"]5005831[/TD]
[TD]Purchasing[/TD]
[TD]127.00[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]267[/TD]
[TD="align: right"]Sep-12[/TD]
[TD="align: right"]5005831[/TD]
[TD]Purchasing[/TD]
[TD="align: right"]151.76[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]268[/TD]
[TD="align: right"]Sep-12[/TD]
[TD="align: right"]5005831[/TD]
[TD]Purchasing[/TD]
[TD="align: right"]238.91[/TD]
[TD="align: right"]517.67[/TD]
[TD]Positive
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]i.e.:[/TD]
[TD][/TD]
[TD]vouch.#[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"]5003750[/TD]
[TD="colspan: 3"]All of its amounts are negatives.[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"]5005762[/TD]
[TD="colspan: 4"]Its amounts are "mixed" (ngtv & postv).
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"]5005831[/TD]
[TD="colspan: 3"]All of its amounts are positives.
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 4"]Please help me on constructing Formula2.[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"]Thank you.[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[peterhinton]

one min, put wrong thing in then, ill post proper formula now for oyu

 

[peterhinton]

=IF(AND(COUNTIFS(C:C,C3,E:E,"<"&0)>0,COUNTIFS(C:C,C3,E:E,">"&0)>0),"mixed",IF(COUNTIFS(C:C,C3,E:E,"<"&0)=0,"positive","negative"))

 

[snd]

It works perfect! Thank you Peter, you saved me much needed time.