COUNTIFS + TABLE

[Pietro Di Micio]

Hey Guys, I've tried to figure out googling some tips to help me, but unfortunately I couldn't.

Here's my point: I am trying to do something like this =COUNTIFS($M$27:$X$100000;"DEAL";$D$27:$D$100000;"NAME"), in other words MX is a table that a need to find "DEAL" and count when also finds a NAME in another column.

Someone could help me?

Tks in advance.
Pietro.

 

[Fluff]

How about

=SUMPRODUCT(($M$27:$X$100000="DEAL")*($D$27:$D$100000="NAME"))

 

[Pietro Di Micio]

How about

=SUMPRODUCT(($M$27:$X$100000="DEAL")*($D$27:$D$100000="NAME"))

WoW so simples! Tks a lot

 

[Fluff]

You're welcome & thanks for the feedback.