expanding sumif
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 & ")" |
All times are GMT +1. The time now is 10:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com