in dashboard spreadsheet i have two columns A and B.
A consists of values that has to be Added to get total if corresponding values in B satisfies the condition.
the condition is that the value in B must be >200 and <300.
i tried sumifs but it is not supported in dashboard.
can someone please help me with the formula or any other alternative.
thanks in advance