Hi, I have been using the following that does work
=SUMIF(F3:F1298,TRUE,AM3:AM1298)/COUNTIF(F3:F1298,TRUE
This allows me to find all the TRUE results in column F and adds up how many TRUE's were found

Now I need to add 2 more columns within this formula. As you can see, I already have "F" column and I need to add "G3:G1298" & "H3:H1298" for "G" & "H" columns into formula. What would the new formula look like? I have not been able to figure it out
Thanks to anoyone who can help
Kyle

I'm not up to speed with programming but if you recorded a macro fo
summing the other columns with the criteria you want you would be hal
way to being able to plice this in to your present code!

Simo

--
Message posted from http://www.ExcelForum.com