Thread: Count cells that contain "Y" in columnA IF contains"X" in columnB
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SteveG SteveG is offline
external usenet poster
  
Posts: 1
Default Count cells that contain "Y" in columnA IF contains"X" in columnB

Hollie,

SUMPRODUCT does not allow you to use an entire column or row (A:A) as a
range. Just change to something like,

=SUMPRODUCT((Offers!H1:H65000="J White")*(Offers!Y1:Y65000="Y"))

Should have warned you of that.

HTH

Steve


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

Reply With QuoteReply With Quote