Sum values(column C) based on unique value(column A) after filtering(column B)

[liakos]

Hello everybody,

I need some help creating a formula.
I have an excel file with 3 columns and I need to sum values of column C, based on the unique values of column A.
I achieved that using the formula '=SUMPRODUCT((C3:C13/COUNTIF(A3:A13;A3:A13)))' but when I use filter in column B, the result is not updated.

I attached a picture of a sample spreadsheet.
Could you please help me?

Thanks in advance,
Liakos

 

[liakos]

Odd, that works for me. Try confirming the formula with Ctrl Shift Enter, rather than just Enter.

Fluff you rock my friend!
It worked just perfect after I confirmed the formula with Ctrl Shift Enter!

Thanks a lot!

 

[Fluff]

You're welcome & thanks for the feedback.