| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumif with two conditions,current financial year date
thank you its working perfectly
Shane Devenshire wrote: Hi, If you are using 2007 then =SUMIFS(F1:F1000,A1:A1000,"John",B1:B1000,"="&M1 ,B1:B1000,"<="&M2) This illustrates how to reference the cell for the start and end of the fiscal year. If you just reference the cell without the "-"& part you will be testing two dates, no a range of dates onless you enter the date as text entries: =4/1/09 <=3/31/10 Otherwise in 2003 and earlier: =SUMPRODUCT(--(A1:A1000="John"),--(B1:B1000=DATE(2009,4,1)),--(B1:B1000<=DATE(2010,3,31),F1:F1000) This illustrates another method of referenceing the dates. I want to sum a range F1:F1000,if range A1:A1000 ="John" and date range B1: B1000 =current financial year date(financial year is 1stApril to 31stMarch) [quoted text clipped - 9 lines] I need funtion to sum John's Current year total Amout value,inthis case the total is 800 -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200907/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sum a range based on current financial year and client id | Excel Discussion (Misc queries) | |||
| How do I get Excel to display which financial year a date is in? | Excel Worksheet Functions | |||
| Using SUMIF for a financial value AND a DATE | Excel Discussion (Misc queries) | |||
| How to convert date to financial year format 2006-07 | Excel Worksheet Functions | |||
| How to compare a date with financial year | Excel Discussion (Misc queries) | |||
Threaded Mode
