SUM IF - Quarterly Calculations

[dixiebritt]

I am needing a formula in my revenue column is only added for the Quarter chosen in column A

Quarter	Revenue
Q1	500
Q2	250
Q3	350
Q4	100
Q1	2500

<tbody>
</tbody>

I want a formula that will extract only the revenue for each time "Q1" is listed. This can not be a pivot table, as it is pulling the data into another worksheet.

 

[gaz_chops]

Try

=sumifs($B$2:$B$100,$A$2:$A$100,"Q1")

 

[dixiebritt]

yes , thank you - i had it backwards

 

[gaz_chops]

You're welcome.

 

[dixiebritt]

Question - what if my data is on-going and I want my formula to auto calculate based on new entries. for example i have 100 rows, but only 5 rows of data as listed above. then next week i add another 5 rows of data with the same criteria. i want my formula to auto calculate based on data i put in. I changed the row number from 5 to 100, but it is returning an "value" error code?????

 

[gaz_chops]

It should work! Did you change the 5 to 100 in both parts? They have to be the same size.

=sumifs($B$2:$B$100,$A$2:$A$100,"Q1")

 

[dixiebritt]

OMG - long day...operator error

 

[gaz_chops]

lol easy done