Help with Excel

[gjmac2]

I need help. I have 2 columns on worksheet entitled 10-07, and I need to have a function that looks for specific values in each column, and return the result to a seperate worksheet. Here is what the columns look like:


Region Code Sum

North 502 1
Southeast 501 1
North 511 1
Southeast 504 1

Now, I need help in figuring out a function that looks in the region column for "Southeast", and then the Code column for "501", and sums the result for the Sum column. I have tried using an IF function, Lookup and Vlookup, and keep getting errors. Any help would be greatly appreciated.

 

[xlbo]

have a look at SUMIF in excel help file

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[gjmac2]

Thank you, that helped out a bunch. Thanks.