akhsanfitrianto wrote:Help me,... in Excel

=COUNTIFS($K$3:$K$19,O18,$E$3:$E$19,$P$17)

What the formula from Open Office Calc?

thanks.

Help yourself! Read the first post in this thread, then the second (Villeroy's first answer). See what is repeated and what is changed. Make the same changes in your formula.

If you need this to work in both Excel and Calc, read the fourth post (Villeroy's second). The logic of that solution is a bit more elusive, but the solution is just as easy to translate to your formula.

Either way, only 3 characters need to be changed.

OOo 3.3.0 and Apache OOo 3.4.1/4.0.0, on Ms Windows 7 and Mac OS-X.