COUNTIF formula problems

[CazzyP]

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

 

[Pete_UK]

Try this:

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

adjust the ranges to suit.

Hope this helps.

Pete

 

[CazzyP]

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

Try this:

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

adjust the ranges to suit.

Hope this helps.

Pete

 

[Pete_UK]

You're welcome.

Pete

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






- Show quoted text -