Thread: How do I set up a formula to add column a if column b = cell c1?
View Single Post
  #23   Report Post  
Posted to microsoft.public.excel.worksheet.functions
croberts327 croberts327 is offline
external usenet poster
  
Posts: 2
Default How do I set up a formula to add column a if column b = cell c
I also have a similar problem to Michelle and Tami.

A B C
20 1" 3 3/4"
24 3/4" 3 3/4"
16 3/4" 3 1/4"
8 1" 3 1/4"
12 3/4" 2 1/2"

I need a formula that will look at the bolt diameter in column b and the
bolt length in column c and sum that size from a bolt count in column a. I
found a way based on the formula for Tami, but it obviously won't return the
correct sum I have bolts with 2 different diameters and the same length.


Reply With QuoteReply With Quote