Help with formula involving multiple columns
Hi
I dont know if this is been addressed in the past or if someone could help me.
I am trying to sum or count the times one item shows in a list but has values between one amount and the other. For example, there are three columns: one has phone numbers, the other shows the area they belong to, and the third shows how many times that number has been used. I need to calculate, for example, how many calls are between 0 and 10 times for one area, one for calls between 11 and 30, etc. I appreciate the help; below is an example of the table.
Toll-Free NumberMarket AreaCompleted Calls Total between 0 and 10total between 11 and 30Phone number 1Market Area 11 Market Area 1????????Phone number 2Market Area 11 Phone number 3Market Area 12 Phone number 4Market Area 13 Phone number 5Market Area 13 Phone number 6Market Area 14 Phone number 7Market Area 15 Phone number 8Market Area 16 Phone number 9Market Area 17 Phone number 10Market Area 110 Phone number 11Market Area 111 Phone number 12Market Area 115 Phone number 13Market Area 123 Phone number 14Market Area 128 Phone number 15Market Area 129
Hi I dont know if this is been addressed in the past or if someone could help me.I am trying to sum or count the times one item shows in a list but has values between one amount and the other. For example, there are three columns: one has phone numbers, the other shows the area they belong to, and the third shows how many times that number has been used. I need to calculate, for example, how many calls are between 0 and 10 times for one area, one for calls between 11 and 30, etc. I appreciate the help; below is an example of the table. Toll-Free NumberMarket AreaCompleted Calls Total between 0 and 10total between 11 and 30Phone number 1Market Area 11 Market Area 1????????Phone number 2Market Area 11 Phone number 3Market Area 12 Phone number 4Market Area 13 Phone number 5Market Area 13 Phone number 6Market Area 14 Phone number 7Market Area 15 Phone number 8Market Area 16 Phone number 9Market Area 17 Phone number 10Market Area 110 Phone number 11Market Area 111 Phone number 12Market Area 115 Phone number 13Market Area 123 Phone number 14Market Area 128 Phone number 15Market Area 129 Read More
