sumproduct formula for summing desingation wise

Hi
Please find attched a sample file
I would like to arrive the amount paid designation wise in colum in AY COLUM using sumproduct without pivot table
pls help

Hi,

Try the following in AY4:

=SUMPRODUCT(--(D$4:D$73=AX4),AR$4:AR$73)

Hi
It works great
Thanks

HI
can you please give formula for count of designation according to gender without pivot table
I am getting some trouble there
Pls help

Try

=COUNTIFS(D:D,AX4,E:E,"M")

and

=COUNTIFS(D:D,AX4,E:E,"F")