Summing numbers only if they correspond to another column???

[pshearer]

Been working on this forever so I decided to join this forum to try to find out. There has to be a better way on this.
I added an attachment. Column A is my "week number" and column E is my sales amount.

I'm trying to create a formula that sums the sales amount, only if it corresponds to a certain week number. I know sumif formulas, but can't get them to work well for this. For example, I want it to sum all the sale that happened in week one, then all the ones in week 2, then all the ones in week 3, and so on. There has to be an easier way than doing a sumif for each individual week and manually changing the week number in the sum if formula.

Could there be a character you can use in a formula to make the sumif week number "running?" So you could then just type in the formula once and pull it all the way down for the year, so the formula will work for the every week throughout the year? Thanks so much for helping.

[peterjuhnke]

hello
I think this is what your after
=SUMIF($A$1:$A$28,A1,$E$1:$E$28)
you will need to extend the range to suit your data
regards
peter

[martindwilson]

=SUMIF(A:A,ROWS($A$1:A1),E:E) would do that but it would be hard to pick out a week
why notjust number say column g down 1 to 52 then =SUMIF(A:A,g1),E:E) and fill down
or try in f1
=IF(A2<>A1,SUMIF(A:A,A1,E:E),"") filled down

[Richard Buttrey]

Hi, and welcome to the forum

In F1 and then copied / dragged down

=SUMIF(A:A,ROW(),E:E)

[pshearer]

Hi, and welcome to the forum

In F1 and then copied / dragged down

=SUMIF(A:A,ROW(),E:E)

Thanks for all the help guys; This is the answer I was looking for. Thanks again; saves me tons of time.

[AlKey]

Please see attached file with formulas

[peterjuhnke]

please see attached
peter

[osamaidrees88]

please see attached
peter

Just applied your trick to one of my own files, it worked, thanks man, you are the saviour

[martindwilson]

lol id have thought since there are 52 unique weeks in a year just numbering from 1 to 52 would do
but attached are 4 ways including a pivot table