SUMIF or SUMIFS

Hi all

im trying to sum qualifying cells in column "X" if the corresponding value of cell in column "L" is less than 2.5

also corresponding value in column "D" must be the same as cell "AH3"

i have tried but im stuck

would appreciate any help

many thanks

Paul

Re: SUMIF or SUMIFS

Thanks Alan

that seems what i was trying to do but couldnt

i will try it when i get home

best regards+ Reply to Thread

Paul

Re: SUMIF or SUMIFS

Just to say it worked perfect

many thanks Alan

Paul