| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sumif problem
On Thu, 23 Jun 2005 20:49:57 -0400, "Tom Ogilvy" wrote:
=SUMIF(A:A,"05*",F:F) This won't work if the account number is an actual number (rather than alphnumeric) stored as 511111 for example and formatted to display a leading zero (0511111). Likely this is not the case. The OP did state that the account numbers were TEXT, but yours is a good warning. --ron |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMIF problem | Excel Worksheet Functions | |||
| Sumif problem | Excel Worksheet Functions | |||
| SumIf Problem | Excel Discussion (Misc queries) | |||
| SUMIF problem | Excel Worksheet Functions | |||
| SUMIF problem | Excel Worksheet Functions | |||
Threaded Mode
