| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif criteria appears twice
How would one set up a formula for:
Range B1:B20 is text and is sometimes duplicated, range A1:A20 has amounts. If duplicated I need the amount of the later dated one to be the formula result. Thanks for your time. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMIF Criteria | Excel Worksheet Functions | |||
| how do i count the number of times criteria appears in a worksheet | Excel Worksheet Functions | |||
| SUMIF with two criteria | Excel Discussion (Misc queries) | |||
| nested sumif or sumif with two criteria | Excel Worksheet Functions | |||
| SUMIF with more than 1 criteria | Excel Worksheet Functions | |||
Threaded Mode
