Solved

# IF statements going wrong

Posted on 2006-06-19
235 Views
I have a client who is using if statements to find out totals of sales stats for each of their sales people. When he uses an IF statement within a SUM formula it works fine by picking up the sales person and summing their figures, but when he tries to put an IF statement in any of the other formulas it does not give the right infomation....using formulas in the form {=AVERAGE(IF(A4:A11=A2, B4:B11, 0))}

A                       B
Salesperson1

Salesperson1      13
Salesperson1      15
Salesperson1      16
Salesperson1      23
Salesperson2      3
Salesperson2      3
Salesperson2      3
Salesperson2      3

67      SUM(IF(A4:A11=A2, B4:B11, 0))
8      AVERAGE(IF(A4:A11=A2, B4:B11, 0))
8      COUNT(IF(A4:A11=A2, B4:B11, 0))
23      MAX(IF(A4:A11=A2, B4:B11, 0))
0      MIN(IF(A4:A11=A2, B4:B11, 0))

does this make sense to anyone?

0
Question by:Microtech
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• 2
• 2

LVL 4

Accepted Solution

Nat_c earned 250 total points
ID: 16935219
Excel has specific formula to use for goal your trying to acheive, try using

sumif
daverage
countif
dmax
dmin

They allow you to specify criteria to apply to the sum, count, etc

Let me know if you need help with the syntax of these

Nat
0

LVL 17

Author Comment

ID: 16935575
sorry this should have been in the excel topic area... passing information on... thanks
0

LVL 17

Author Comment

ID: 16935682
That worked great thank you.
0

LVL 4

Expert Comment

ID: 16935691
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

### Suggested Solutions

Quality of Service (QoS) options are nearly endless when it comes to networks today. This article is merely one example of how it can be handled in a hub-n-spoke design using a 3-tier configuration.
Shadow IT is coming out of the shadows as more businesses are choosing cloud-based applications. It is now a multi-cloud world for most organizations. Simultaneously, most businesses have yet to consolidate with one cloud provider or define an offic…
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…