Create a funktion
 

Hi,

I need to create a formula that will look in 2 different colums and return a
count.


Column A will contain data (I, O)

Column G contains data(F, J, N)

I want to know how many I

I want to be able to create a formula that will count the positive results
if Column A= 1 & Column B= F

Someting like..
=countif(A2:A500,"A")*(B2:B500,"F")) I don't know who to get the second half
of the formula in the same cell.

I'm not as knowledgable on complex formulas as the ones I use usually are
the basic versions.

Can anyone help?
--
Your advice is appreciated
:-)

--
Jenna

Create a funktion
 

Try this:

=SUMPRODUCT((A2:A500="I")*(B2:B500="F"))

HTH,
Elkar


"Jenna" wrote:

Hi,

I need to create a formula that will look in 2 different colums and return a
count.


Column A will contain data (I, O)

Column G contains data(F, J, N)

I want to know how many I

I want to be able to create a formula that will count the positive results
if Column A= 1 & Column B= F

Someting like..
=countif(A2:A500,"A")*(B2:B500,"F")) I don't know who to get the second half
of the formula in the same cell.

I'm not as knowledgable on complex formulas as the ones I use usually are
the basic versions.

Can anyone help?
--
Your advice is appreciated
:-)

--
Jenna

Create a funktion
 

thank you!
--
Jenna


"Elkar" skrev:

Try this:

=SUMPRODUCT((A2:A500="I")*(B2:B500="F"))

HTH,
Elkar


"Jenna" wrote:

Hi,

I need to create a formula that will look in 2 different colums and return a
count.


Column A will contain data (I, O)

Column G contains data(F, J, N)

I want to know how many I

I want to be able to create a formula that will count the positive results
if Column A= 1 & Column B= F

Someting like..
=countif(A2:A500,"A")*(B2:B500,"F")) I don't know who to get the second half
of the formula in the same cell.

I'm not as knowledgable on complex formulas as the ones I use usually are
the basic versions.

Can anyone help?
--
Your advice is appreciated
:-)

--
Jenna