I would like to write a IF statement that says if a value in Column Q is greater then 5%, then calculate for each column (R:AQ) the average of those rows with a value greater than 5% in Column Q.
I would like to write a IF statement that says if a value in Column Q is greater then 5%, then calculate for each column (R:AQ) the average of those rows with a value greater than 5% in Column Q.
Last edited by rhudgins; 04-13-2010 at 01:28 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks