rookie needs a macro...

Denise · Nov 3, 2003

Colum H - rows 5-42 contain various positive and negative
number

I need... sum of all negative numbers in the column to
appear in H44
I need ....sum of all positive numbers in the column to
appear in H45

How do I enter the macro in the worksheet?

Thanks very much!!

Kevin Stecyk · Nov 3, 2003

Hi Denise,

I think you meant you need a formula.

H44

=Sumif(H5:H42, "<0")

H45

=Sumif(H5:H42, ">=0")

Hope that helps.

Regards,
Kevin

Don Guillett · Nov 3, 2003

You shouldn't need a macro. Take a look in HELP index for SUMIF worksheet
function.

Bob Phillips · Nov 3, 2003

Denise,

A worksheet function does it

H44: =SUMIF(H5:H42,"<"&0)

H45: =SUMIF(H5:H42,">"&0)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Dave R. · Nov 3, 2003

Don't need a macro for this, try the SUMIF function, it does exactly what
you like.

CLR · Nov 3, 2003

Dunno about a macro, but this can be easily done with formulas........

in H44 put =SUMIF(H5:H42,"<0")
in H54 put =SUMIF(H5:H42,">0")

and if you want the total number of each, rather than the sums,

for the negative numbers, use =COUNTIF(H5:H42,"<0")
and the positive numbers, use =COUNTIF(H5:H42,">0")

hth
Vaya con Dios,
Chuck, CABGx3

Denise · Nov 3, 2003