Thread: How do I set up a formula to add column a if column b = cell c1?
View Single Post
  #24   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JBeaucaire[_98_] JBeaucaire[_98_] is offline
external usenet poster
  
Posts: 1
Default How do I set up a formula to add column a if column b = cell c

Perhaps an array formula like this:

=SUMPRODUCT(--($B$1:$B$5=F1),--($C$1:$C$5=G1),A1:A5)

F1 = bolt diameter desired
G1 = bolt length desired

Confirmed with CTRL-SHIFT-ENTER


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=54906

Reply With QuoteReply With Quote