COUNTIF formula problems
 

I have a range of data (example below) and I'm trying to identify every time
a row has both VTF and 1a in their respective columns. I've tried everything
I can think of but I'm not getting the right answer (would be 1 in the
example below).

Please can anyone help?!
Many thanks
Caroline

Example:

column 1 column 2 column 3
ABC complete 1a
VTF incomplete 1a
VTF incomplete 2

COUNTIF formula problems
 

Try this:

=SUMPRODUCT((A1:A100="VTF")*(C1:C100="1a"))

adjust the ranges to suit.

Hope this helps.

Pete

On Jan 29, 3:51*pm, CazzyP wrote:
I have a range of data (example below) and I'm trying to identify every time
a row has both VTF and 1a in their respective columns. *I've tried everything
I can think of but I'm not getting the right answer (would be 1 in the
example below).

Please can anyone help?!
Many thanks
Caroline

Example:

column 1 * * *column 2 * * *column 3
ABC * * * * * * complete * * *1a
VTF * * * * * * incomplete * *1a
VTF * * * * * * incomplete * *2

COUNTIF formula problems
 

Thanks very much Pete. I'll give that a go!


"Pete_UK" wrote:

Try this:

=SUMPRODUCT((A1:A100="VTF")*(C1:C100="1a"))

adjust the ranges to suit.

Hope this helps.

Pete

On Jan 29, 3:51 pm, CazzyP wrote:
I have a range of data (example below) and I'm trying to identify every time
a row has both VTF and 1a in their respective columns. I've tried everything
I can think of but I'm not getting the right answer (would be 1 in the
example below).

Please can anyone help?!
Many thanks
Caroline

Example:

column 1 column 2 column 3
ABC complete 1a
VTF incomplete 1a
VTF incomplete 2

COUNTIF formula problems
 

You're welcome.

Pete

On Jan 30, 9:51*am, CazzyP wrote:
Thanks very much Pete. *I'll give that a go!



"Pete_UK" wrote:
Try this:

=SUMPRODUCT((A1:A100="VTF")*(C1:C100="1a"))

adjust the ranges to suit.

Hope this helps.

Pete

On Jan 29, 3:51 pm, CazzyP wrote:
I have a range of data (example below) and I'm trying to identify every time
a row has both VTF and 1a in their respective columns. *I've tried everything
I can think of but I'm not getting the right answer (would be 1 in the
example below).

Please can anyone help?!
Many thanks
Caroline

Example:

column 1 * * *column 2 * * *column 3
ABC * * * * * * complete * * *1a
VTF * * * * * * incomplete * *1a
VTF * * * * * * incomplete * *2- Hide quoted text -

- Show quoted text -