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) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumif based on last digit of account list
Try this:
=SUM(IF(RIGHT(C6:C9,1)="1",D6:D9,0)) This is an array formula and should be entered with CTRL-SHIFT-ENTER instead of just Enter. If done properly, the formula should be surrounded by { } Or, another option: =SUMPRODUCT(--(RIGHT(C6:C9,1)="1",(D6:D9)) HTH, Elkar "Ted Metro" wrote: =SUM((RIGHT(C6:C9,1)="1")*D6:D9) |
Reply |
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 |