COUNT

[Barathrums]

HI ALL,

I JUST WANT TO KNOW HOW TO COUNT ROWS FROM TWO COLUMNS DATE1 AND DATE2 AFTER SUBTRACTING ALL THE RESULT GREATER THAN ZERO WILL BE COUNTED. ATTACH FILE IS MY SAMPLE FOR FURTHER DETAILS OF MY PROBLEM.

THANK YOU.

BEST REGARDS.

[Bob Phillips]

Nothing was attached, and using all caps is considered rude in net etiquette.

[Barathrums]

Nothing was attached, and using all caps is considered rude in net etiquette.

[GTO]

Maybe:
=SUMPRODUCT(--(A2:A12="james"),--(C2:C12-B2:B12>=1))

Hope that helps,

Mark

[Barathrums]

Maybe:
=SUMPRODUCT(--(A2:A12="james"),--(C2:C12-B2:B12>=1))

Hope that helps,

Mark


Thank you so much Mark..It really helps us..