Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
sumif formula in a macro
I have reposted this question. thanks in advance for any
help. Thanks Rob, but this is not what i am looking for. I need the difference between the sumif of a column from the amt 50. Then a message box saying excess of 10. Also, this is to modify a macro. Thanks again -----Original Message----- Paul, Here's an example: In a new worksheet, Put values from 1 to 10 in cells A1:A10 In another cell use this formula: =SUMIF (A1:A10,"<5",A1:A10) 1+2+3+4 = 10 Other criteria can be "<=5", "=17", etc... There's a Conditional Sum Wizard Add-In which can help you out too. Rob "paul" wrote in message ... 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 & ")" . .. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro with sumif | Excel Discussion (Misc queries) | |||
macro with sumif | Excel Worksheet Functions | |||
multiply formula where 1 cell has a (sumif) formula as a result | Excel Worksheet Functions | |||
Is there a MAXIF formula similar to the SUMIF formula? | Excel Discussion (Misc queries) | |||
macro that sumif a specific range | Excel Programming |