Formula for counting multiple variables in a spreadsheet
 

I have a spreadsheet with multiple columns. I am trying to create a formula
that would return a count for the number of values in column A that has the
same value I am looking for in column E.

The formula that I thought would be if(e4:e1000="FL1",countif(A4:a100,a4),0)

Any ideas....

Formula for counting multiple variables in a spreadsheet
 

SUMPRODUCT should work. Try this,

=SUMPRODUCT((A4:A1000=A4)*(E4:E1000="FL1"))

The ranges need to be the same size.

Cheers,

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=516341

Formula for counting multiple variables in a spreadsheet
 

The formula would be:
=COUNTIF(A4:A1000,E1)

This would count all the incidence of E1 in A1:A1000. Likewise you could
copy this formula beside every unique value in Column E.


"smorgan" wrote:

I have a spreadsheet with multiple columns. I am trying to create a formula
that would return a count for the number of values in column A that has the
same value I am looking for in column E.

The formula that I thought would be if(e4:e1000="FL1",countif(A4:a100,a4),0)

Any ideas....

Formula for counting multiple variables in a spreadsheet
 

Thanks for the response. I may have not been real clear. I am looking to
count all of instances of say "John Deere" in Column A that have the value of
"FL" in Column E.

WCoaster wrote:
The formula would be:
=COUNTIF(A4:A1000,E1)

This would count all the incidence of E1 in A1:A1000. Likewise you could
copy this formula beside every unique value in Column E.

I have a spreadsheet with multiple columns. I am trying to create a formula
that would return a count for the number of values in column A that has the
[quoted text clipped - 3 lines]

Any ideas....

Formula for counting multiple variables in a spreadsheet
 

The SUMPRODUCT will work.

=SUMPRODUCT((A4:A1000="John Deere")*(E4:E1000="FL"))

This counts the number of times that a cell in column A = John Deere
where the corresponding cell in column E contains "FL".

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=516341

Formula for counting multiple variables in a spreadsheet
 

Extremely creative solution. Thanks, I am sure I will be able to use that
somewhere soon.

"SteveG" wrote:


SUMPRODUCT should work. Try this,

=SUMPRODUCT((A4:A1000=A4)*(E4:E1000="FL1"))

The ranges need to be the same size.

Cheers,

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=516341

Formula for counting multiple variables in a spreadsheet
 

Dear Sir/Madam

I have just started MS Excel and VBA so If u have got any source
material plz send this mail id


yours

sudhir