sumif formula in a macro

P

paul

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





.
Click to expand...
..
 
Top