No Pivot table

[thebigtable]

I will attempt to explain this better. I can't use a pivot table, but I would like to:

Reference a cell (BN) that has a week number referencing a date in another cell;
and sum any information in (BW) that has that weeknumber in the cell BY

BN--------BW------BX-----BY
1 25 6 - sum of BW1:BW3
2 25 8 -
3 25 2 -

Hope this helps.
J@thebigtable

 

[hkaplan2]

Sounds like a sumif.

Something like:

=SUMIF(BW2:BW5,BN1,BY2:BY5)

Where BW2:BW5 contains the week numbers

BN2 contains the week you are matching to the list in BW

BY2:BY5 contains the numbers you want to sum if BW column = BN1.

 

[thebigtable]

COL BN:BN contains the week numbers 25,26,27. There may be multiples of the same week number.
BN contains the week you are matching to the list in BW
BW:BW contains the numbers I want to sum if BW column = BN.

My example did not format correctly the first attempt. Hope this helps.