
July 19th, 2006, 08:19 AM
|
|
Registered User
|
|
Join Date: Jul 2006
Posts: 1
Time spent in forums: 1 m 42 sec
Reputation Power: 0
|
|
Quote: | Originally Posted by kpholley Trying to write onw formula that will look at a date range(column A) as a condition and sum numbers (column B) that fall in that condition. the kicker is the condition is a date range. The two formulas below work exclusively but I cannot combine them into one:
SUMIF(A2:A9,">06/30/2006",B2:B9)
SUMIF(A2:A9,"<08/01/2006",B2:B9)
What I want to say to say (in laymens terms) is
SUMIF(A2:A9,">06/30/2006" and "<08/01/2006",B2:B9)
Any help would be greatly appreciated.
Kevin |
Why not use sum(if(...))
You can nest as many as you like.
|