Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
unique entry sum
sorry first post had bad formatting
Thankyou for everyone's help yesterday it was great. I have one last thing that is bafaling me to do with the same thing. I have a column in D that shows the number of days an invoice is over due | A | B | C | D | 10 N/A yes 0 10 N/A yes 0 11 N/A no 2 11 N/A no 2 12 N/A yes 0 13 N/A no 1 13 N/A no 1 13 N/A no 1 I wish to sum the number in coulmn D for those that are overdue (no in Column C) and that are unique entries (column A, invoice number), in this example there are 4 unique entries. With the help from everyone yestarday i have manged to be able to sum up the number of invoices that were overdue (Column C=no), so in the obove example the result would be 2 (invoice 11 and 13) by useing this array formula. =SUM(N(FREQUENCY(IF(C:C="No",MATCH(A:A&"",A:A&"",0 )),MATCH (A:A&"",A:A&"",0))0)) I am at a loss at how i can then extend this to sum up the same corrospnding values in column D. Oh and i then need to also devide this by the total number of invoices that failed. Hope someone can help. Many Thanks Gareth |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
unique cell entry | Excel Discussion (Misc queries) | |||
Unique entry - Data Validation | Excel Discussion (Misc queries) | |||
Counting Unique entry from Concatenated list | Excel Worksheet Functions | |||
Unique entry count | Excel Discussion (Misc queries) | |||
How do I make a unique entry | New Users to Excel |