SUMIF formula in Chart expression

[#1]

sum(if(Quantity>=Seats),Quantity) what am I doing wrong.

I want the chart to sum for only those deals where the Quantity is greater than the variable Seats. I tried it iwth the ,0) at the end and still didn't work.

[#2]

Change brackets...

SUM( IF(Quantity >= Seats,Quantity))

[#3]

will the same thing work for summing only those that are maximum date.

I have data by day for ending inventory but I want the chart to only sum the last date's data:

sum (if(Date = Max(Date),Cost)) but it doesn't work

[skaredovs]

dcpy, you need to use Total for Max() in this case:

sum (if(Date = Max(total Date),Cost))

BR