john3j
08-19-2009, 10:58 AM
Hello All:
I have two numbers that I have to come up with so that I can calculate an average.
First, a total number of actions. In order to do this, the following conditions have to be met. G2:G1000 = "09" and AL2:AL1000 = "Awarded"
For the other number, I have to get a dollar amount so I dont know if I could use a sumproduct or not. For this total obligated number the following conditions need to be met. if G2:G1000 = "09" it should sum those conditions that are met within the range U2:U1000. In other words, if it was an action in 09, the we need to go ahead an add it to the sum.
From here I would calculate the average by dividing the two. If you could even write me a formula that does all of this on one line that would be great. Please help!
Thanks:dunno
I have two numbers that I have to come up with so that I can calculate an average.
First, a total number of actions. In order to do this, the following conditions have to be met. G2:G1000 = "09" and AL2:AL1000 = "Awarded"
For the other number, I have to get a dollar amount so I dont know if I could use a sumproduct or not. For this total obligated number the following conditions need to be met. if G2:G1000 = "09" it should sum those conditions that are met within the range U2:U1000. In other words, if it was an action in 09, the we need to go ahead an add it to the sum.
From here I would calculate the average by dividing the two. If you could even write me a formula that does all of this on one line that would be great. Please help!
Thanks:dunno