I'm trying to use multiple criteria in my SUMIF and COUNTIF functions and I'm
unable to figure out how to nest/combine them using the same rationale as
shown below [ =SUMIF(F9:F129,"<="&M2,A9:A129) ]

I want to do something that would be like: and("<="&M2,"="&M3)
but can't get the syntax right...

Thanks


"T. Valko" wrote:

What does your formula look like?

It should look like this:

=SUMIF(F9:F129,"<="&M2,A9:A129)

--
Biff
Microsoft Excel MVP


"Lost in Query" wrote in message
...
I cannot get SUMIF to work for me at all.

I have a Sum Range F9:F129 = numbers
I have a Criteria Range A9::A129=Dates
and I have a Criteria M2 (TODAY)
I want all numbers in the range F9:F129 to be added thus SUM all up to
TODAY
<=M2 depending on Dates in column A9:A129 but it just comes back with nil
it
doesn't seem to recognise that M2 is a number (TODAY) and thus it will not
calculate anything.

Chris

If you want to sum based on a date range:

M2 = lower boundary date
M3 = upper boundary date

=SUMIF(F9:F129,"="&M2,A9:A129)-SUMIF(F9:F129,""&M3,A9:A129)

Note that the boundary dates are included in the sum.

Format as General or Number

--
Biff
Microsoft Excel MVP


"DaleS" wrote in message
...
I'm trying to use multiple criteria in my SUMIF and COUNTIF functions and
I'm
unable to figure out how to nest/combine them using the same rationale as
shown below [ =SUMIF(F9:F129,"<="&M2,A9:A129) ]

I want to do something that would be like: and("<="&M2,"="&M3)
but can't get the syntax right...

Thanks


"T. Valko" wrote:

What does your formula look like?

It should look like this:

=SUMIF(F9:F129,"<="&M2,A9:A129)

--
Biff
Microsoft Excel MVP


"Lost in Query" wrote in message
...
I cannot get SUMIF to work for me at all.

I have a Sum Range F9:F129 = numbers
I have a Criteria Range A9::A129=Dates
and I have a Criteria M2 (TODAY)
I want all numbers in the range F9:F129 to be added thus SUM all up to
TODAY
<=M2 depending on Dates in column A9:A129 but it just comes back with
nil
it
doesn't seem to recognise that M2 is a number (TODAY) and thus it will
not
calculate anything.

Chris