Hello everyone,
I have a bit of a problem expanding the formula below to
show when sales exceed 50. I do not want it to report
when it is less than 50. The formula sumif all sales and
their values. I will like for it to report in the next
row say column H. Sales exceeded by whatever number. Eg.
If sumif total is 60 and want it to report "Sales
exceeded by 10". Even just the number will do. Thanks for
any help and attempt in advance.

c.Offset(1, 3).Formula = "=Sumif(" & rng1.Offset(0,
3).Address & _
",""Sales""," & rng1.Offset(0,
4).Address & ")"