| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Dynamically determining when a month ends
I'm not sure what went wrong for you,
but here's a sample implementation: http://cjoint.com/?blxSiW6QdK Moomancow3k_newusers.xls I've tried to structure it to follow closely the sheetname, range references, etc you provided earlier in your posted formula: =SUMIF(Income!A2:A700,=AND("=38718","<=38748")),I ncome!C2:C700) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Moomancow3k" wrote in message ... When I tried to enter your code into a new spreadsheet file, I put the data you said to into sheet1, as well as the line of code... I renamed sheet2 "Income", and entered some data... However, I get an "Invalid Cell Reference Error" on Sheet1 with your forumula... Any ideas? I copied and pasted your line for Sheet1!C1 exactly. Thanks! -- Moomancow3k ------------------------------------------------------------------------ Moomancow3k's Profile: http://www.excelforum.com/member.php...o&userid=30339 View this thread: http://www.excelforum.com/showthread...hreadid=500025 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need cell formula to subtotal gross by month for a quarter | Excel Discussion (Misc queries) | |||
| 4 and 5 week months | Excel Discussion (Misc queries) | |||
| Working days left in the month compared to previous months | Excel Worksheet Functions | |||
| Add one month to the previuos month | Excel Discussion (Misc queries) | |||
| Month Year Date Format | Excel Worksheet Functions | |||
Threaded Mode
