Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello
I would like to learn how to calculate amonts in a sumif that are between 2 dates. eg =SUMIF('Costs detail'!$Q$2:$Q518,A8,'Costs detail'!$O$2:$O$542) ......where A8 is currently just a month reference (I mean it looks at cell A8 where I type in the month). So in other words, I'd like it to look up values in another worksheet called Costs Detail, providing the associated dates are between, say 1st Feb and end of April. Any help always please. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculating dates | Excel Worksheet Functions | |||
CALCULATING DATES | New Users to Excel | |||
Calculating dates | Excel Worksheet Functions | |||
Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
I need help calculating dates? | Excel Worksheet Functions |