Hi Pete,

One more problem, is there any way to make the h6 a range, such as H6:H25, I
tried that, but it didn't work. In other words, If Column A is Feb and
column H6 through H25 contains an "A", sum AX6 through AX25? I can't seem to
get it to work. Any help at all would be greatly appreciated.

Thanks,

D
--
DMM


"Pete_UK" wrote:

If h6 begins with the letter a then it must be text, so you will have
to change the + sign to & (in which case you probably also want "0"
instead of just 0), like so:



Hope this helps.

Pete

On Aug 28, 9:12 pm, soconfused
wrote:
That's not working and I don't know why? Any other ideas?
--
DMM



"roadkill" wrote:
I assume that "jan" in your example if in row 6 of column a (otherwise you'll
need to make the necessary adjustment).

=if(and(month(a6)=1,left(h6,1)="a"),h6+h7,0)

Note that the date in a6 needs to be a date/date serial #, not text.

Will

"soconfused" wrote:

I am trying to write something like this:

If the date in column a = jan and the 1st letter of column h6 is a, add
h6&h7 together, if not 0
--
DMM- Hide quoted text -

- Show quoted text -