Sumproduct with multiple criterias

What does (-- do?

wow...u are really a great help! u saved me! =) it's working,,,
i hope it's not too much to ask,,,i understand formulas but i am having difficulties formulating them...
if i want to do the same but this time i have 3 criterias

=SUMPRODUCT(--(YEAR(O13:O5167)=H3)*(N13:N5167="OK"))*(P13:P5167 HAS A DATE VALUE AND (Q13:Q5167 HAS A DATE VALUE, THEN COUNT

>:D<

Originally Posted by FDibbins

Hi and welcome to the forum

Just add it to the end...

=SUMPRODUCT(--(YEAR(O13:O5167)=H3)*(M13:M5167="OK"))

-----


wow...u are really a great help! u saved me! =) it's working,,,
i hope it's not too much to ask,,,i understand formulas but i am having difficulties formulating them...
if i want to do the same but this time i have 3 criterias

=SUMPRODUCT(--(YEAR(O13:O5167)=H3)*(N13:N5167="OK"))*(P13:P5167 HAS A DATE VALUE AND (Q13:Q5167 HAS A DATE VALUE, THEN COUNT

>:D<

Originally Posted by FDibbins

=sumproduct(--(year(o13:o5167)=h3)*(n13:n5167="ok"))*(p13:p5167>0)*(q13:q5167>0))

it is returning a wrong result...bec when i tried to filter 2013 year with "OK" value in N column and a date value in P column and filtered year 2013 in Q column result should be 15 in the cell I5...

you are a big helped...i thought i'm going crazy everytime i formulate wrong formulas...

Originally Posted by FDibbins

Happy to help and thanks for the feedback

you are a big helped...i thought i'm going crazy every time i formulate wrong formulas...

Originally Posted by FDibbins

When I used this, I got 17?

=SUMPRODUCT(--(YEAR(O13:O5167)=H3)*(N13:N5167="OK")*(P13:P5167>0)*(Q13:Q5167>0))

Originally Posted by FDibbins

When I used this, I got 17?

=SUMPRODUCT(--(YEAR(O13:O5167)=H3)*(N13:N5167="OK")*(P13:P5167>0)*(Q13:Q5167>0))

HELLO...sorry my bad...i am referring with different column to count,,,it's alright now...i got it...
i think i will be needing the assistance of this forum 'till i finally complete my file. I never registered to any forums like this..it's my first time,,i tend to just google everything...Thanks to you and to others who are helping to solve some formula issues.. it's more of like an answered prayer...again,,,SUPER BIG THANKS!

Originally Posted by FDibbins

When I used this, I got 17?

=SUMPRODUCT(--(YEAR(O13:O5167)=H3)*(N13:N5167="OK")*(P13:P5167>0)*(Q13:Q5167>0))

----------------
Hi,,,

i hope you don't mind,,,,this is regarding with the same excel sheet that i have attached the other day ago...i wanted to ask if i want to count a multiple criteria,,,lets say countifs N column is "OK"
and
P= date value
and
Q=date value
then count 1


--------
and also...

if N column is "ongoing" and P column has no date OR N column is "OK" or "No PUNCHLIST" value and P column has no date

looking forward for your help.

Thanks in advance...