View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dksaluki dksaluki is offline
external usenet poster
 
Posts: 48
Default 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.