Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumif based on last digit of account list
=SUM((RIGHT(C6:C9,1)="1")*D6:D9) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to convert list of 5 digit zip codes to ranges where possible | Excel Worksheet Functions | |||
How do move folders from web based email account to outlook? | Excel Discussion (Misc queries) | |||
sort numbers based on initial digit. | Excel Discussion (Misc queries) | |||
I wish to change the last digit in a list of random numbers. To a. | Excel Worksheet Functions | |||
How do I setup a list box that has several account numbers so use. | Excel Worksheet Functions |