Forum Discussion
Solved
need help figuring out a formula to use to add figures if they are in certain quarter.
hi I have two questions: I have a spreadsheet where I log sales, and next to sales number, on next column, I put what quarter it was from, (like, q1, q2, etc.) 1. I figured out how to make th...
2) In C2:
=SUMIF(B$2:B2,"Q1",A$2:A2)
In D2:
=SUMIF(B$2:B2,"Q2",A$2:A2)
In E2:
=SUMIF(B$2:B2,"Q3",A$2:A2)
In F2:
=SUMIF(B$2:B2,"Q4",A$2:A2)
Select C2:F2 and then fill down.
2) In C2:
=SUMIF(B$2:B2,"Q1",A$2:A2)
In D2:
=SUMIF(B$2:B2,"Q2",A$2:A2)
In E2:
=SUMIF(B$2:B2,"Q3",A$2:A2)
In F2:
=SUMIF(B$2:B2,"Q4",A$2:A2)
Select C2:F2 and then fill down.
HansVogelaar thank you so much! this worked perfectly!
