Thread: Formula for counting multiple variables in a spreadsheet
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SteveG
 
Posts: n/a
Default 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

Reply With QuoteReply With Quote