conditional summing

  • Thread starter Thread starter Brian K
  • Start date Start date
B

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?
 
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
 
Back
Top