Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calcuate Totals
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!! -- Bruce |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calcuate totals based on specific criteria | Excel Worksheet Functions | |||
How to calcuate the difference between two times in tenths of a mi | Excel Discussion (Misc queries) | |||
calcuate bond yields | Excel Worksheet Functions | |||
How do I calcuate an IC50 from analyze it? | Excel Worksheet Functions | |||
calcuate sales by date and segments | Excel Worksheet Functions |