Thread: Count If Column A = x and Column B = y
View Single Post
  #14   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chin via OfficeKB.com Chin via OfficeKB.com is offline
external usenet poster
  
Posts: 13
Default Count If Column A = x and Column B = y
Yes, countifs( ) works only in Excel 2007. Not sure about sumproduct( ).
Please try:

=SUMPRODUCT((A1:A100="A")*(B1:B100="B"))

Please advise if this works in Excel 2003.


Trish wrote:
I get "#NAME?" error ;(

Trish, please try:

[quoted text clipped - 6 lines]
the first column to see if it's A, then look in 2nd column to see if it's B,
then count it... is that possible?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200904/1

Reply With QuoteReply With Quote