looking up different columns

[Whitelighter_Carlos]

I need some help in trying to get some information from a large spreadsheet.

I hacve 4 sets of columns that are boken up into percetage category, percentage category, etc.

I need to be able to determine the average for the percentage based on category. So for example, the two categories are "phones" and "emails"

I need an end result of all the averages for "phones" and overall average for "emails".

Any help you can provide would be greatly appreciated.

Thanks,
Carlos

 

[Oaktree]

Can you post a sample of your data? It is not immediately clear how your data is arranged...

 

[Whitelighter_Carlos]

Yes, for example:

A1=85%
B1=Email
A2=92%
B2=Phones

C1=75%
D1=Phones
C2=100%
D2=Emails

 

[Oaktree]

Try something like:

=AVERAGE(IF(B1:D2="Phones",A1:C2))

which is an array formula and must be confirmed with CTRL+SHIFT+ENTER (doing so correctly will result in Excel putting {}'s around your formula in the formula bar)

 

[Whitelighter_Carlos]

I tried this but it didn't work and I don't think I understood the formula?