| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with Sumif and Right()
I am trying to use sumif to add up a column of data. The hitch is I want to
compare the last four right characters of each line contained in the range. My code is xlrng2 & 4 are Dim as Range xlApp.Range("m21") = xlApp.WorksheetFunction.SumIf(Right(xlRng2, 4), "CPCT", xlRng4) |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Problem with Sumif and Right()
xlrng2 & 4 are Dim as Range
xlApp.Range("m21") = xlApp.WorksheetFunction.SumIf(xlRng2, "*CPCT",xlRng4) -- Regards, Tom Ogilvy "JEff" wrote in message ... I am trying to use sumif to add up a column of data. The hitch is I want to compare the last four right characters of each line contained in the range. My code is xlrng2 & 4 are Dim as Range xlApp.Range("m21") = xlApp.WorksheetFunction.SumIf(Right(xlRng2, 4), "CPCT", xlRng4) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sumif problem | Excel Discussion (Misc queries) | |||
| Sumif problem | Excel Worksheet Functions | |||
| SUMIF Problem | Excel Discussion (Misc queries) | |||
| SUMIF problem | Excel Worksheet Functions | |||
| SUMIF problem | Excel Worksheet Functions | |||
Hybrid Mode
