VBA code to get the SUM product from MAXIF

[yedhs]

anyone please help me solved this problem
i need to sum all the max value with some condition from several array
i knew how to do it with formula but i need the VBA code for that

this is the file that still become a problem for me maxif.xlsx

regards,
YEDI

[Parth007]

Check the Attached Macro...

[yedhs]

thank you Parth, that was a big help for me but if the range not just 5 coloumns do i have to write the formula array like that
can't i use while or for to calculate that?

regards,
YEDI

[Parth007]

Hi Yedi,

Yes ytou can change the code accordingly...

Please Login or Register  to view this content.