| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum column D based on column A
I have a worksheet having claim numbers in column A invoice numbers in column
B and invoice amoiunts in column D. A single claim may have one or more invoices How can I have claim totals/sum/amount in column M?(Prefarably in the same row as the last invoice for each claim) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sum column D based on column A
Hi Anthony
Try =IF(COUNTIF($A$1:$A1,A1)=COUNTIF($A$1:$A$12,A1),SU MIF($A$1:$A$12,A1,$D$1:$D$12),"") Amend ranges to suit -- Regards Roger Govier "anthony" wrote in message ... I have a worksheet having claim numbers in column A invoice numbers in column B and invoice amoiunts in column D. A single claim may have one or more invoices How can I have claim totals/sum/amount in column M?(Prefarably in the same row as the last invoice for each claim) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding a Custom Column based on an existing Column (EXPERT) | Excel Worksheet Functions | |||
| Count number of cells and total in one column, based on another column suffix | Excel Worksheet Functions | |||
| Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Discussion (Misc queries) | |||
| Text to column and selecting values based on a different column | Excel Worksheet Functions | |||
| move contents of column C based on criteria related to column A | Excel Discussion (Misc queries) | |||
Linear Mode
