Proper use of sumif()

[murrsumm]

I want to sum data in a column of numbers by selecting only those data that correspond to a given month. My formula looks like this -

=SUMIF($D$2:$D$50,isnumber,$E2:$E50)

D2:D50 is the column containing a numeric value corresponding to the month a particular event of interest occurred. The cells in that column will contain either that numeric value or they will be blank.

E2:E50 is the column of data from which I want to select for calculating the sum.

Obviously, the "isnumber" is generating a #Name error. How to I correctly specify that criterion for this function?

[Norie]

Any chance you could upload a sample workbook?

Click on GO ADVANCED, scroll down and click Manage Attachments.

[MarvinP]

Hi murrsumm and welcome to the forum,

Something like this? Are all those numbers in column D greater than Zero?

=SUMIF(D:D,">0",E:E)

[murrsumm]

I'll be darned! That worked. I would have never thought to encaps the criterion in quotes. Thank you!