I have 1st column of dates & second column for categories(say ABCD) & then 24 columns of hourly production & then one column for total(calculated by "sum" function).

I need a vlookup formula that gives me categoryvise total production for the day.

Can anyone help me on this