Formula2 needed, please.

[snd]

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

<tbody>
</tbody>

 

[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.