If I understood him correctly then:
A B C
1 3.6 1
2 4.6 3
3 4.2 5
4 12/13/2005 ?
5 11/12/2005 ?

"Biff" wrote:

Hi!

This is very confusing (at least it is to me):

(column B 4 and <5)

1-3 are numbers and 4,5 are dates

If 4 and 5 are dates like 12/4/2005, 12/5/2005, then there is no date that
is 4 AND <5.

Or am I just having one of those days?

Biff

"boooney" wrote in message
oups.com...
Hi--

I'm trying to sum an array that meets certain conditions into a single
cell

A B C
1
2
3

I need the function to sum column C for instances whe
(column A = 1 or 2 or 3) and
(column B 4 and <5)

1-3 are numbers and 4,5 are dates

Can anyone help with the syntax I should use? I've found array formula
samples of AND and OR, but not both together. Everything I've tried so
far has failed to produce the result I need.

Thanks in advance.