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
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")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks