Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sum if formula
Help!. I have this sumif formula that calculates total
General items. I will like to extend this formula to show the total of General items when it exceeds 50. I will like for it to report on Column G. Example General Items if 60. It should report as excess of 10 Items or something like that. Is this possible? If yes, I will appreciate any help. This is the current formula: c.Offset(6, 3).Formula = "=Sumif(" & rng1.Offset(0, 3).Address & _ ","" General items ""," & rng1.Offset (0, 4).Address & ")" |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Commenting custom formula fields/formula on formula editor | Excel Programming |