Multiple conditioning

[torpido]

hi people,

can somebody help me with multiple conditioning in SumIf and CountIf function..
attached is a file which i need help with,
if you see on top there are 4 heading(T1,T2,T3 and T4), each has two function below them(SumIf and CountIf), i need each to count or sum cells if two conditions are met, for example:

if k11:20=t1 and E11:20=Auto then H11:20 should be summed.

simmilar thing in countif function.

thanks and regards

[NBVC]

Try:

=SUMPRODUCT(--(K11:K803="T1"),--(E11:E803="Auto")) to count

and

=SUMPRODUCT(--(K11:K803="T1"),--(E11:E803="Auto"),H11:H803) to sum

[torpido]

once again, this forum never stops amazing me.
thanks a bunch

[NBVC]

Please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

[raveepoojari]

Really i didnt get this formula..

as ur instracations i put =SUMPRODUCT(--(K11:K803="T1"),--(E11:E803="Auto")) foumula but result its showing two.. really answer is only one

tats y i am attching that file also..plz tell me exact formula for other cells also.

i am waiitn for ur reply

thank u

[martindwilson]

you really should start a new thread but as this is related...
you have put
=SUMPRODUCT(--(K11:K803="T1")--(E11:E803="auto")) in d2
it is missing a ","
should read
=SUMPRODUCT(--(K11:K803="T1"),--(E11:E803="auto"))