Posted to microsoft.public.excel.worksheet.functions
|
|
How do I set up a formula to add column a if column b = cell c
thank you...worked beautifully!
"JBeaucaire" wrote:
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
|