Specific function to get the sum
Hi all,
I have an excel table with data like:
ticket amount invoice n°
45 145$ 7025.222-(75 )
45 120$ 7025.222-(75)
45 12$ 7025.222-(25)
46 555$ 7025.235
46 10$ 7025.236
47 188$ 7026.735-(80)
47 52$ 7026.735-(20)
What I'd like to do is: to make the sum of each ticket "like 45" but
with an argument when the invoice ends with -(75) make sum of ticket
45 = [(145$+120$)/75%],if invoice ends with -(25) ignores to include
in sum.
and when the invoice ends without brackets "like ticket 46"; make sum
[555$+10$], and when invoice ends with -(80) make sum of ticket "like
47" = [(188$+52$)/80%] and ignore to include invoices end with -(20)
in this sum.
Could any body help.
Thanks
Lassaad
|