On 9 Apr, 17:00, "PCLIVE" wrote:
Good point!

--

"Dave Peterson" wrote in message

...



just in case...

=SUMPRODUCT(--(A2:A20="NMSFC"),--(B2:B20=char(149)))

PCLIVE wrote:

Just noticed that after the message was posted, it no longer included
Chr149. *Replace the middle double quotes with Chr149. *I'm sure you
probably figured that out though.

Regards,
Paul

--

"PCLIVE" wrote in message
...
Here's one way:
You'll need to specify an actual range rather than the entire column.

=SUMPRODUCT(--(A2:A20="NMSFC"),--(B2:B20="""))

Adjust your range as needed.

HTH,
Paul

--

wrote in message
....
I thought this would be a fairly simple formula but just dont seem to
be able to get the right syntax.

Rows in column B will contain the text, 'Nichs' or 'NMSFC'.
Rows in column C may contain Chr149 "

At bottom of column C I need a count, where column B = 'NMSFC' and
column C has a " in it.

I had a go at this with the following formula, but it doesn't work. I
have tried using AND but again cant quite get it right.
=IF($B:$B="NMSFC",COUNTIF(C5:C263,"*"),"")

Any advice or help would be appreciated as completely stuck and cant
find a previous post that helps.

Thanks Carl

--

Dave Peterson- Hide quoted text -

- Show quoted text -

Thanks for this, worked a treat. Never even considered using
SUMPRODUCT.
Thanks again