Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
summing up values in a column based on values in 3 other columns
Hi,
I have the following problem. I have a big table and I want to add up let's say values in column D, whenever Column A, B, C have a specific value (e.g. A=US, B=CA, C=SF). (Actually I need summed up values for all combinations of A, B, C) I have a solution working with loops, but this takes a lot of time,. Does anybody know a quicker solution (e.g. using some kind of find for 3 values or something else ...) Kind regards, AXEL |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Summing rows based on other column values | Excel Worksheet Functions | |||
summing values in a data table based on criteria in another column | Excel Worksheet Functions | |||
looking up values in 1 column based on 2 other columns | Excel Worksheet Functions | |||
Get values in a column based on values in two other columns | Excel Programming | |||
Summing one column if two other columns' values appear in other sh | Excel Worksheet Functions |