Value Error in Aggregate for Sum function

Hi, hemantparmar!

the AGGREGATE function only works with arrays with operations between 14 and 19.

If you want to sum with condition, you can use SUMPRODUCT or SUMIF instead:

=SUMPRODUCT(D2:D15,--(C2:C15=C17))
=SUMIF(C2:C15,C17,D2:D15)

Blessings!