Sumproduct,Countif, I don't Know!!!!!
 

Hi,
I am trying to count how many record meet three conditions. I have
been using a Sumproduct formula for two colums but now I need a hird it
is not working. It is hard to descibe but if a Sumproduct formula could
work it would look like this:

=SUMPRODUCT((MAIN!$AJ$1:$AJ$65534="Stairs")*(MAIN! $B$1:$B$65534="Sick")*(MAIN!$C$1:$C$65534="Door")

I know this formula will never work as Sumprduct will only look up two
criteria and add a third value. Please; any suggestions would be
greatly recieved.

Regards

G


--
Cobbcouk
------------------------------------------------------------------------
Cobbcouk's Profile: http://www.excelforum.com/member.php...o&userid=32143
View this thread: http://www.excelforum.com/showthread...hreadid=564924

Sumproduct,Countif, I don't Know!!!!!
 

You're actually very close. Use this:
=SUMPRODUCT(--(MAIN!$AJ$1:$AJ$65534="Stairs"),--(MAIN!$B$1:$B$65534="Sick"),--(MAIN!$C$1:$C$65534="Door"))


--
Jim


"Cobbcouk" wrote:


Hi,
I am trying to count how many record meet three conditions. I have
been using a Sumproduct formula for two colums but now I need a hird it
is not working. It is hard to descibe but if a Sumproduct formula could
work it would look like this:

=SUMPRODUCT((MAIN!$AJ$1:$AJ$65534="Stairs")*(MAIN! $B$1:$B$65534="Sick")*(MAIN!$C$1:$C$65534="Door")

I know this formula will never work as Sumprduct will only look up two
criteria and add a third value. Please; any suggestions would be
greatly recieved.

Regards

G


--
Cobbcouk
------------------------------------------------------------------------
Cobbcouk's Profile: http://www.excelforum.com/member.php...o&userid=32143
View this thread: http://www.excelforum.com/showthread...hreadid=564924

Sumproduct,Countif, I don't Know!!!!!
 

Awesome, thank you, I knew I was in the right area I just could not work
out that last step. Again Many Thanks :)


--
Cobbcouk
------------------------------------------------------------------------
Cobbcouk's Profile: http://www.excelforum.com/member.php...o&userid=32143
View this thread: http://www.excelforum.com/showthread...hreadid=564924

Sumproduct,Countif, I don't Know!!!!!
 

Sorry, can the same formula be used for more criteria/variables, or is
it limited to three?


--
Cobbcouk
------------------------------------------------------------------------
Cobbcouk's Profile: http://www.excelforum.com/member.php...o&userid=32143
View this thread: http://www.excelforum.com/showthread...hreadid=564924

Sumproduct,Countif, I don't Know!!!!!
 

I don't know the limit if there is one. I have never reached it.
--
Jim


"Cobbcouk" wrote:


Sorry, can the same formula be used for more criteria/variables, or is
it limited to three?


--
Cobbcouk
------------------------------------------------------------------------
Cobbcouk's Profile: http://www.excelforum.com/member.php...o&userid=32143
View this thread: http://www.excelforum.com/showthread...hreadid=564924