Formulas

S

soconfused

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
 
R

roadkill

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
 
P

Pete_UK

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:

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

Hope this helps.

Pete
 
S

soconfused

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
 
P

Pete_UK

Try this:

=SUMPRODUCT((MONTH(A6:A25)=2)*(LEFT(H6:H25,1)="A")*(AX6:AX25))

Assumes proper dates in column A and column H begins with "A".

Hope this helps.

Pete
 
S

soconfused

Thank you, Thank you, Thank you, you have just saved me so many hours of
calculations and errors.
 
S

soconfused

Thank you, thank you, thank you, you have just saved me so many hours of
calculation work and errors.
 
Top