| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
help with sumif formula
Here is my column A (formated as a Date):
1-Oct 2-Oct 3-Oct 4-Oct 5-Oct 6-Oct ..... .... Then in Column B i plug in the number of miles I ran. What i would like to do is Sum column B if Column A contains "Oct", or "Sep", etc.. How do i use the SumIf formula when Column A is formated as a date? Looking for "...Oct" does not work for me. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SumIf Formula | Excel Worksheet Functions | |||
| Nesting a sumproduct formula within a sumif formula. | Excel Discussion (Misc queries) | |||
| multiply formula where 1 cell has a (sumif) formula as a result | Excel Worksheet Functions | |||
| Embed AND formula in SUMIF formula | Excel Discussion (Misc queries) | |||
| Is there a MAXIF formula similar to the SUMIF formula? | Excel Discussion (Misc queries) | |||
Threaded Mode
