Adding values with like information

J

JD

How do I create a function that adds up certain numbers in one column that
all have a certain value in another column. For example:
column A Column B
557 4
557 6
445 7
336 20

The values are offset by different numbers of rows as well. Ideally I'd want
to know the sum of all of Column B whose Column A value is the same. There
are about a 1000 of unique values in Column A so I don't want to have to go
and do this by hand.

Thanks.
 
J

JD

Thanks for the suggestion. Using the subtotal method (or any other) I also
have a column that already has the predetermined total of the subareas
(column b in my example) that should presumable be the same as the calculated
subtotal. Is there anyway to determine with true/false if the subtotals of
each unique value in column a as we just calculated equal the predetermined
value that was given?

column A Column B Column C
 
J

JD

Also, I care only if the calculated subtotal is greater than or less than 5
than the predetermined number in column C
 
J

JD

I don't understand what you mean by the last posting.

In my example below how would you verify that D1=C1 or if there were
subtotals of column B for each group in column A how would you compare them
to the values in column D.

"APN" "Square feet" "Sum of B"
"Input"
column A Column B Column C
Column D
Row 1 557 4 10
11
Row 2 557 6 10
11
Row 3 445 7 7
7
Row 4 336 20 20
7
 
R

ryguy7272

Hey JD! I think you lost me here. At first, I thought this was a very
simple thing, but now I can't tell what you want. Please repost; your
questions will reappear at the top of the list and you should get some
responses pretty quick. Just try to describe the question differently from
the way you did before. Towards the end, I couldn't tell what was going on,
and I suspect others couldn't either, and that's why no one else jumpped in
here.

Good luck!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Return the value from one range that does not exist in another 0
Sum Values from different column 1
Conditional sums 1
How to add values in one column based on values in another column 6
Count Unique Values in 1 Column based on Date Range in another Column 28
custom data validation on cells with data validation values 2
How do I get the unique values from a column in excel? 6
Excel Pivot Table - Counting Unique Values within one column of da 1

Top