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 & ")"



.

..