| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want to use sumif to sum up a column based on a range of dat
=SUMPRODUCT(--(YEAR(A1:A100)=2006),B1:B100)
"Bernard Liengme" wrote: =SUMPRODUCT(--(YEAR(A1:A100=2006),B1:B100) best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Ricky from Pine Island" <Ricky from Pine wrote in message ... I would like to sum up a column of agent commissions using a range of dates. For example: the agent has input all of his commissions for january 1, 2006 through april 30, 2007. I would like a sumif formula that sums up the commissions for just the year 2006. Is this possible with sumif? I have tried using = and <= but it doesn't work. Thank you, Ricky |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup based on range of dates | Excel Worksheet Functions | |||
| return based on range of dates | Excel Worksheet Functions | |||
| Sumif based on column A and title of another column | Excel Discussion (Misc queries) | |||
| How to count dates within a certain range in a column with mutiple date range entries | Excel Worksheet Functions | |||
| can I use a range of dates as a criteria when using sumif? | Excel Worksheet Functions | |||
Threaded Mode
