Search results

OK, I reduced all margin of error and removed the word Team and space so all I have are the letters A-K ('minus the letter I). The formula '=COUNTIF(C:C,"A")+COUNTIF(G:G,"A") works to count the Teams. Col E will have numbers representing X-Wins and X-Loses So if Team A has 8 Wins against...

The first formula works ' =COUNTIF(C:C,"Team G")+COUNTIF(G:G,"Team G") but '=SUMPRODUCT((C:C="Team G")*(G:G="Team G")*(E:E)) returns #value

Thx, I tried that and it returns a 0 i have even trid to use SUMPRODUCT found on Chandoo site but it didn't work either.

Opps, this is a public link https://skydrive.live.com/redir.aspx?cid=2b770c659a94550d&resid=2B770C659A94550D!195&parid=2B770C659A94550D!102

here is a link to the example file https://skydrive.live.com/redir.aspx?cid=2b770c659a94550d&resid=2B770C659A94550D!195&parid=2B770C659A94550D!102&authkey=!AJr0x3rcZ9O1O9k

Chandoo I am a begineer and love your site and ExcelUser. I have 2 questions regarding COUNTIFS and what would be the best formula to use? First, I cannot seem to get COUNTIFS to work. I get no error but it returns a 0. I used the Help file and Google but can't seem to get it to work for...

just hide the columns and rows manually

https://skydrive.live.com/redir.aspx?cid=2b770c659a94550d&resid=2B770C659A94550D!102&authkey=jDtHRZDizDc%24

Ahhh haaaa, got it. but didnt use the code....

is there a way for me to upload an example?

2007, i have a spreadsheet that someone sent to me that only displays columns a-f and row 1-19. they are not hidden and when i view the code for the sheet or workbook there is no code such as yours. i have possed the question to the person who sent it to me but they have no idea as the workbook...

your process works if i want to sit there and hide the rows and columns, tedious task. the columns and rows that i dont hide. all i changed was the number and column. Sub HideRowsCols() If Application.Version < 13 Then Columns("g:IV").EntireColumn.Hidden = Not...

Thx, i added the code saved it as Macro-enabled but it does not work

how do you get a worksheet to only display say columns A-Z and Row 1-50?