| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Year To Date Sumif question
Thanks Bob - that fixed it perfectly!
Cheers Anne "Bob Phillips" wrote: =SUMIF(C1:BB1,"<="&'Weekly Summary'!$G$1,C3:BB3) -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Anne" wrote in message ... Every week I have to calculate year-to-date sales, so wanted to do a sumif statement at the end. I have the current week number listed on a separate worksheet. wk # 1 2 through to 52 code wk01 wk02 wk52 YTD Total Shop A AX1650 129 20 0 Shop B AX3502 0 0 0 I thought the formula for Shop A would look like: =SUMIF(C1:BB1,"<='Weekly Summary'!$G$1",C3:BB3) However, I keep getting 0 as the answer. It would also be great to just have it recognize wk01 or wk15 and let me do the less than/equal to the second row, but don't know if the "wk" stops that. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sumif for months and year | Excel Worksheet Functions | |||
| Year question | Excel Discussion (Misc queries) | |||
| Year-to-date year to date formula | Excel Worksheet Functions | |||
| Date formula: return Quarter and Fiscal Year of a date | Excel Discussion (Misc queries) | |||
| leap year question | Excel Discussion (Misc queries) | |||
Threaded Mode
