Adding up (SUM) totals per quarter

[bartvdg]

I have a sheet with one column showing the quarters and another column the revenues.
there are multiple rows with data, how can I show the totals per quarter in a separate sheet?
What formula could I use?

 

[Oscar Cronquist]

[Table="width:, class:head"][tr=bgcolor:#E0E0F0][th] [/th][th]

A​

[/th][th]

B​

[/th][th]

C​

[/th][th]

D​

[/th][th]

E​

[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

1​

[/td][td]Quarter[/td][td]Revenue[/td][td][/td][td]Q1[/td][td]

200​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

2​

[/td][td]Q1[/td][td]

100​

[/td][td][/td][td][/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

3​

[/td][td]Q2[/td][td]

300​

[/td][td][/td][td][/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

4​

[/td][td]Q1[/td][td]

100​

[/td][td][/td][td][/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

5​

[/td][td]Q2[/td][td]

400​

[/td][td][/td][td][/td][td][/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: Sheet17[/td][/tr][/table]

Formula in cell E1:
=SUMIF(A2:A5,D1,B2:B5)

 

[bartvdg]

Thank you Oscar. This was what I needed.
Have a great day.