Get instant live expert help on I need help with quarters in a year

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

Hi, I'm trying to sumif an index match and although it's working for the first year, the formula is throwing up incorrect values for the rest of the term- I can't figure it out! (Got a 10 year cashflow in quarters, trying to sum the rent in each year)
Solved by I. H. in 14 mins
How do I sort by month on an excel spread sheet? I am NOT good at excel but need to sort the year into 4 quarters. Help
Solved by B. Q. in 30 mins
I need a formula that shows in which quarters did the verticals start beating target. Where they beat target, which weeks do they start becoming the most accurate? In quarters where the miss target, which weeks?
Solved by K. W. in 29 mins
Hello, I have a summary revenue tab and a pipeline tab. I want to have the pipeline numbers sum across the various quarters. I am not sure how to do a sumifs function between the quarters. For example, I would like d8 in the pipeline to sum in the 3/31/2019 tab in the P&L when I drag the formula across
Solved by O. Y. in 14 mins
Need help merging quarters for Q1'17, Q2'17, Q3'17 and Q1'18
Solved by X. J. in 22 mins