Counting column A depending on data in column C

[glov3r]

Hi I have a bunch of numbers in column A all the way to A3000
i then have week numbers in column C . I then have a table with week numbers at the top . In that table I want a formula that looks for all the week ones then counts the number in the same row in column A

then i I will change the formula for week 1-54 ...


thanks in advance.

 

[iggydarsa]

Have you tried pivot table?

 

[glov3r]

Yes but I need to calculate all the numbers together . Then add more cells to it . Which isn't working with a pivot table . I need a formula that will give me a total of all the numbers found in column a that Macth the number of the week.