conditional summing

[Brian K]

I want to write a formula that will sum revenue by
quarter based on a specific revenue date (i.e. 9/15/03 =
3rd quarter) for a list of accounts. Can't seem to get
it right with sumif 'cause I have to determine if the
date is in the quarter I am interested in... any thoughts?

 

[Taliesin]

if, for example column A contains the date and B contains the revenue

C1=if(and($A1>[start of quarter],$A1<[end of quarter]),$B1,"")

drag this formula into columns D E & F (changing the dates) and then do a
total of each column