Sum of field corresponding to max date from a table

[#1]

Hi Guys,

Please help in finding max date from a table.

Problem description is as follows

The list box here shows the date values present in my table. The highlighted date is the max date in that table

The table below shows the rows in the table corresponding to the max date

Now my requirement is something like below:

When I come to a particular sheet i will have a gauge chart wherin I have to display the sum(msc_med_v_med_count) for the max date. But I will not have the list box or any selection object in the sheet.

How I can I do this? Please help me with a solution

Thanks in advance

Praveena

[#2]

Maybe something like

sum( if(DATE = MAX(DATE),msc_med_v_med_count))

[RedSky001 · Accepted solution]

See the example attached, does that help.

In your case something like this:

= num(sum(if(Date=Max(Total Date),msc_med_v_med_count)) ,'##.##','.')  / 100

[#4]

Thanks Mark.. This worked for me