Calcuate Totals

[Bruce D.]

I am using excel 2007. I have a spreadsheet that has the following data:

Acct No Date PPT Paid Sales Tx Total

300389124 4/19/09 60.46 4.54 65.00
300389124 4/19/09 32.55 2.45 35.00
300389124 4/19/09 65.00 0 65.00
300389124 4/19/09 35.00 0 35.00

(PPT Paid + Sales Tax = Total amount). I need to only see the total records
with the paid and sales tax amounts if they are present. I can't exclude all
records with 0 sales tax because there are other records that have no sales
tax and are valid. I need to check for the above situation when it occurs and
would like to see just the first 2 records not all 4 records. I have tried
the remove duplicates on the menu bar, it helps out for some but not in every
case.

Hope this makes sense.

Thanks to all!!

 

[Simon Lloyd]

If you are only looking to exclude any that do not include sales ta
then assuming your data starts in A1 put this in E1 and copy dow
=IF(D1<>0,SUM(C11),""

I am using excel 2007. I have a spreadsheet that has the following data

Acct No Date PPT Paid Sales Tx Tota

300389124 4/19/09 60.46 4.54 65.0
300389124 4/19/09 32.55 2.45 35.0
300389124 4/19/09 65.00 0 65.0
300389124 4/19/09 35.00 0 35.0

(PPT Paid + Sales Tax = Total amount). I need to only see the tota
record
with the paid and sales tax amounts if they are present. I can't exclud
al
records with 0 sales tax because there are other records that have n
sale
tax and are valid. I need to check for the above situation when i
occurs an
would like to see just the first 2 records not all 4 records. I hav
trie
the remove duplicates on the menu bar, it helps out for some but not i
ever
case

Hope this makes sense

Thanks to all!

-
Bruce


--
Simon Lloyd

Regards
Simon Lloy
'Microsoft Office Help' (http://www.thecodecage.com)