Aggregate formula sumIF,AverageIF problem for sales calculation more than 10000
Dear Sir, I am working on Aggregate sumIf formula for sales report But unable to make it . There is a error coming specific formula is invalid .Please check my formula and find the problem . I think syntax of formula is not correct thats why its showing error .Please give me a demo example for same .Below is my formula
sumif(( "Ford details"."amount" >10000))
ford detials is sales report
amount is Ford details Column
I have to calculate Amount greater than 10000. I have also attached the screenshot
Please Give Aggregate formula syntax for SumIF, count IF , Average IF