View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kyle[_4_] Kyle[_4_] is offline
external usenet poster
 
Posts: 1
Default formula for 3 columns

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