formula to keep a running tally of the number of times a certain w
 

formula to keep a running tally of the number of times a certain word appears
in a spreadsheet...

I'd like one cell that I can refer to that will always show me the number of
times SDP is listed in a spreadsheet.

Thanks in advance

formula to keep a running tally of the number of times a certain w
 

should have looked around before I posted... found my answer:

=SUMPRODUCT(--(L4:L555="sdp"))



"CJZ" wrote:

formula to keep a running tally of the number of times a certain word appears
in a spreadsheet...

I'd like one cell that I can refer to that will always show me the number of
times SDP is listed in a spreadsheet.

Thanks in advance

formula to keep a running tally of the number of times a certain w
 

=SUMPRODUCT(--(L4:L555="sdp"))

An alternative for a single criteria count is:
=COUNTIF(L4:L555,"sdp")

And if the data setup permits using entire* col refs,
then it could be just simply:
=COUNTIF(L:L,"sdp")

*imo, that's an advantage in this instance,
since Sumproduct does not accept entire col references
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"CJZ" wrote in message
...
should have looked around before I posted... found my answer:

=SUMPRODUCT(--(L4:L555="sdp"))

formula to keep a running tally of the number of times a certa
 

thanks Max. that's a better option. appreciate it.

"Max" wrote:

=SUMPRODUCT(--(L4:L555="sdp"))

An alternative for a single criteria count is:
=COUNTIF(L4:L555,"sdp")

And if the data setup permits using entire* col refs,
then it could be just simply:
=COUNTIF(L:L,"sdp")

*imo, that's an advantage in this instance,
since Sumproduct does not accept entire col references
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"CJZ" wrote in message
...
should have looked around before I posted... found my answer:

=SUMPRODUCT(--(L4:L555="sdp"))

formula to keep a running tally of the number of times a certa
 

You're welcome, CJZ !
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"CJZ" wrote in message
...
thanks Max. that's a better option. appreciate it.