Count Formula

[Jagat Pavasia]

dear sir,
I have formula =SUMPRODUCT((F7:F15000="")*(B7:B15000<TODAY()-(K3))*(D7:D15000))
It is working as it should, but I want same formula in count mode,
means how many lines in above formula.

please help me

 

[Peter_SSs]

We don't know quite what might be in some of those ranges, but see if this does what you want.

=SUMPRODUCT((F7:F15000="")*(B7:B15000<TODAY()-(K3))*(D7:D15000<>""))

 

[Peter_SSs]

If that does what you want, this would be a more efficient formula to do it.

=COUNTIFS(F7:F15000,"",B7:B15000,"<"&TODAY()-K3,D7:D15000,"<>")

.. & more efficient for you original formula:

=SUMIFS(D7:D15000,B7:B15000,"<"&TODAY()-K3,F7:F15000,"")

 

[Jagat Pavasia]

We don't know quite what might be in some of those ranges, but see if this does what you want.

=SUMPRODUCT((F7:F15000="")*(B7:B15000<TODAY()-(K3))*(D7:D15000<>""))

thank you so much....Peter.......

it is working as I want...

Thank You Again.....

 

[Peter_SSs]

You are welcome. Thanks for the follow-up.

(BTW, did you try the alternatives I suggested?)