Why formula isn't working?
 

The error i'm getting is (A vlaue used in the formula is the wrong data type.

{=MAX(IF(MONTH(D2:D232)=MONTH(TODAY())-1,H2:H232))}

d2:d232 is either blank or month ex. January
h2:h232 is either blank or a whole number ex.2, 5, 8, 12
Thanks,
Paul

Why formula isn't working?
 

What exactly do you have in D2:D232? In order to use the MONTH
function, those values must be actual dates, not month names or
numbers. An element like MONTH("March") will fail because "March" is
not a date.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

On Thu, 5 Feb 2009 09:29:21 -0800, drose
wrote:

The error i'm getting is (A vlaue used in the formula is the wrong data type.

{=MAX(IF(MONTH(D2:D232)=MONTH(TODAY())-1,H2:H232))}

d2:d232 is either blank or month ex. January
h2:h232 is either blank or a whole number ex.2, 5, 8, 12
Thanks,
Paul

Why formula isn't working?
 

The items in D2 thru D232 need to be Dates for the formula to work.
--
Gary''s Student - gsnu200832


"drose" wrote:

The error i'm getting is (A vlaue used in the formula is the wrong data type.

{=MAX(IF(MONTH(D2:D232)=MONTH(TODAY())-1,H2:H232))}

d2:d232 is either blank or month ex. January
h2:h232 is either blank or a whole number ex.2, 5, 8, 12
Thanks,
Paul

Why formula isn't working?
 

I tried it with 1/1/2009 and still doesn't work. Any ideas?

"drose" wrote:

The error i'm getting is (A vlaue used in the formula is the wrong data type.

{=MAX(IF(MONTH(D2:D232)=MONTH(TODAY())-1,H2:H232))}

d2:d232 is either blank or month ex. January
h2:h232 is either blank or a whole number ex.2, 5, 8, 12
Thanks,
Paul

Why formula isn't working?
 

Using your original set up (where you only had the month name, as text, in
column D), try this array-entered formula...

=MAX(IF(D2:D232=TEXT(MONTH(TODAY()-DAY(TODAY())),"mmmm"),H2:H232))

**Commit formula using Ctrl+Shift+Enter, not just Enter by itself

--
Rick (MVP - Excel)


"drose" wrote in message
...
The error i'm getting is (A vlaue used in the formula is the wrong data
type.

{=MAX(IF(MONTH(D2:D232)=MONTH(TODAY())-1,H2:H232))}

d2:d232 is either blank or month ex. January
h2:h232 is either blank or a whole number ex.2, 5, 8, 12
Thanks,
Paul