A
allie357
I am trying to count the number of unique invoice numbers. However, if
the invoice number has debits and credits I have to go through and
match the debits and the credits. If the total amount is zero, the
invoice number cannot be included in the original count. An example of
an invoice number that will need to be removed from my count is the
last one in the example list.
I was using this formula to help me find the matching credits and
debits but it does not seem to be meeting my needs:
=COUNTIF($H$1:$H1001,$A1&":"&$D1&":"&-$F1)>=COUNTIF($H$1:$H1,$H1)
Can someone help me find a formula that evaluates the invoice number
and all the amounts of that number to see if it adds up to zero. Then,
if it adds up to zero can it be added to a list? I am new at writing a
formula like this.
the invoice number has debits and credits I have to go through and
match the debits and the credits. If the total amount is zero, the
invoice number cannot be included in the original count. An example of
an invoice number that will need to be removed from my count is the
last one in the example list.
I was using this formula to help me find the matching credits and
debits but it does not seem to be meeting my needs:
=COUNTIF($H$1:$H1001,$A1&":"&$D1&":"&-$F1)>=COUNTIF($H$1:$H1,$H1)
Can someone help me find a formula that evaluates the invoice number
and all the amounts of that number to see if it adds up to zero. Then,
if it adds up to zero can it be added to a list? I am new at writing a
formula like this.