Trying to produce blanks cells for some alpha numeric charatcters and not others

[boynejs]

I have a large spread sheet. The values in the column "O" I am referencing are M, T, numbers, and blank cells. I want to keep the T and number values in Column D, but want the M to be a blank cell and the blank cell to remain blank. The following formula does well except it is assigning both T and M as a blank cell.

=IF(COUNTIFS($o$4:$o$34,">=0",$n$4:$n$34,$A$1,$k$4:$k$34,$A4)>=1,SUMIFS($o$4:$o$34,$n$4:$n$34,$A$1,$k$4:$k$34,$A4),"")

Thanks in advance for any help that you can provide!

[FDibbins]

You are getting 0 in the countifs() part because you have text in O28 (for 1944)

[boynejs]

You are getting 0 in the countifs() part because you have text in O28 (for 1944)

I tried an Index and Match function too, but I was getting 0's for blank cells and that messed up my count when I wanted to count dry Easters. All I want to do is retrieve Easter climate data from another work sheet and display it in another work sheet, so I can run some statistics on it. It is a huge work sheet with all sorts of holidays in it.

[FDibbins]

OK see if you can adapt this ARRAY formula to suite your needs....
=INDEX($O$4:$O$34,MATCH($A4&$A$1,$K$4:$K$34&$N$4:$N$34,0))
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.

Note: If you have a large amount of data, ARRAY formulas could slow things down. If this is the case, we can modify that by using a helper in P2, copied down....
=K4&N4
Then that formula becomes a regular formula like this....
=INDEX($O$4:$O$34,MATCH($A4&$A$1,$P$4:$P$34,0))

[boynejs]

OK see if you can adapt this ARRAY formula to suite your needs....
=INDEX($O$4:$O$34,MATCH($A4&$A$1,$K$4:$K$34&$N$4:$N$34,0))
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.

Note: If you have a large amount of data, ARRAY formulas could slow things down. If this is the case, we can modify that by using a helper in P2, copied down....
=K4&N4
Then that formula becomes a regular formula like this....
=INDEX($O$4:$O$34,MATCH($A4&$A$1,$P$4:$P$34,0))

This works great; however, the blank cells are becoming 0s and that will end up messing up my count of Easters without rain.