Forum Discussion
Rhona Gerrard
Aug 28, 2018Copper Contributor
I need help with a Sumif formula
This is totally wrecking my head but I'm looking for a formula for mileage 1201CC TO 1500CC - 0KM TO 1500KM this month: 90 accumulative: 317 So what I want to know is if the accumulative figure is...
SergeiBaklan
Aug 28, 2018Diamond Contributor
Hi Rhona,
That could be
=A1*(39+34*(B1>1500))
where A1=this month; B1=cumulative