27/11/2003Â Â· Hello there! i need to add up the total of Y's in a column of Y and N. i have been using the formula IF(A1="Y",1,0)+IF(A2="Y",1,0) BUT there must be an easier way to add up the number of Y's in a column (or row for that matter)... 10/08/2006Â Â· Use the autosum feature. First put the cursor in the cell that you want the answer to appear in. In the menu bar there is a symbol that looks like a backwards E. Click that button then highlight all cells that you want to add up.

27/11/2003Â Â· Hello there! i need to add up the total of Y's in a column of Y and N. i have been using the formula IF(A1="Y",1,0)+IF(A2="Y",1,0) BUT there must be an easier way to add up the number of Y's in a column (or row for that matter)... How to Fix Excel Numbers That Donâ€™t Add Up If you download bank statement data into Excel, or copy numbers from a website, those numbers might not add up correctly. The bank data might look like numbers, but Excel might see those numbers as text -- not real numbers.

Letâ€™s say that instead of adding up the 2nd column, we want to add up the last column. Rather than expressing the argument with an integer value such as 2, we want Excel to dynamically figure out the last column number. This brings us to the COLUMNS function which returns the number of columns within a range. For example, the following formula will return the number of columns in our table... 10/08/2006Â Â· Use the autosum feature. First put the cursor in the cell that you want the answer to appear in. In the menu bar there is a symbol that looks like a backwards E. Click that button then highlight all cells that you want to add up.

How to Fix Excel Numbers That Donâ€™t Add Up If you download bank statement data into Excel, or copy numbers from a website, those numbers might not add up correctly. The bank data might look like numbers, but Excel might see those numbers as text -- not real numbers.... Letâ€™s say that instead of adding up the 2nd column, we want to add up the last column. Rather than expressing the argument with an integer value such as 2, we want Excel to dynamically figure out the last column number. This brings us to the COLUMNS function which returns the number of columns within a range. For example, the following formula will return the number of columns in our table

## Excel How To Add Up A Column

## Excel How To Add Up A Column

### How to Fix Excel Numbers That Donâ€™t Add Up If you download bank statement data into Excel, or copy numbers from a website, those numbers might not add up correctly. The bank data might look like numbers, but Excel might see those numbers as text -- not real numbers.

- How to Fix Excel Numbers That Donâ€™t Add Up If you download bank statement data into Excel, or copy numbers from a website, those numbers might not add up correctly. The bank data might look like numbers, but Excel might see those numbers as text -- not real numbers.
- How to Fix Excel Numbers That Donâ€™t Add Up If you download bank statement data into Excel, or copy numbers from a website, those numbers might not add up correctly. The bank data might look like numbers, but Excel might see those numbers as text -- not real numbers.
- 10/08/2006Â Â· Use the autosum feature. First put the cursor in the cell that you want the answer to appear in. In the menu bar there is a symbol that looks like a backwards E. Click that button then highlight all cells that you want to add up.
- Letâ€™s say that instead of adding up the 2nd column, we want to add up the last column. Rather than expressing the argument with an integer value such as 2, we want Excel to dynamically figure out the last column number. This brings us to the COLUMNS function which returns the number of columns within a range. For example, the following formula will return the number of columns in our table

### You can find us here:

- Australian Capital Territory: Kaleen ACT, McKellar ACT, Kingston ACT, McKellar ACT, Oxley ACT, ACT Australia 2622
- New South Wales: Tabulam NSW, Tomewin NSW, Merimbula NSW, Holmesville NSW, Tomakin NSW, NSW Australia 2011
- Northern Territory: Yarrawonga NT, Winnellie NT, Mcarthur NT, Tivendale NT, Yirrkala NT, Knuckey Lagoon NT, NT Australia 0847
- Queensland: South Townsville QLD, Minyama QLD, Bohle Plains QLD, Ninderry QLD, QLD Australia 4028
- South Australia: Edillilie SA, Flinders Chase SA, Whitwarta SA, Belton SA, Wynn Vale SA, Woodside SA, SA Australia 5014
- Tasmania: South Burnie TAS, Zeehan TAS, Mt Nelson TAS, TAS Australia 7062
- Victoria: Tottenham VIC, Braeside VIC, West Creek VIC, Sulky VIC, Buangor VIC, VIC Australia 3003
- Western Australia: Strathalbyn WA, Coolbellup WA, Munglinup WA, WA Australia 6037
- British Columbia: Nanaimo BC, Duncan BC, Chase BC, Comox BC, Queen Charlotte BC, BC Canada, V8W 1W5
- Yukon: Little Gold YT, Mayo YT, Ogilvie YT, McCabe Creek YT, Klondike YT, YT Canada, Y1A 8C2
- Alberta: Daysland AB, Hardisty AB, Arrowwood AB, Magrath AB, Rocky Mountain House AB, Drumheller AB, AB Canada, T5K 7J9
- Northwest Territories: Jean Marie River NT, Fort Resolution NT, Fort McPherson NT, Reliance NT, NT Canada, X1A 4L4
- Saskatchewan: Limerick SK, Neudorf SK, Roche Percee SK, Atwater SK, Sturgis SK, Abernethy SK, SK Canada, S4P 7C3
- Manitoba: Niverville MB, Snow Lake MB, Beausejour MB, MB Canada, R3B 7P4
- Quebec: Cote Saint-Luc QC, Marieville QC, Becancour QC, Saint-Noel QC, Sainte-Petronille QC, QC Canada, H2Y 8W8
- New Brunswick: Drummond NB, Grand Bay-Westfield NB, Upper Miramichi NB, NB Canada, E3B 8H1
- Nova Scotia: Louisbourg NS, Liverpool NS, Richmond NS, NS Canada, B3J 8S4
- Prince Edward Island: Hampshire PE, Hunter River PE, Hunter River PE, PE Canada, C1A 3N7
- Newfoundland and Labrador: Long Harbour-Mount Arlington Heights NL, Little Bay Islands NL, Main Brook NL, Main Brook NL, NL Canada, A1B 7J4
- Ontario: Dysart, Dudley, Harcourt, Guilford, Harburn, Bruton, Havelock, Eyre and Clyde ON, Gildale ON, Monck ON, Flanders, Shetland ON, Maxwell, Grey County ON, Long Sault ON, ON Canada, M7A 9L6
- Nunavut: Belcher Islands NU, Southampton Island NU, NU Canada, X0A 7H9

- England: Kidderminster ENG, Beeston ENG, Dewsbury ENG, Scunthorpe ENG, Wigan ENG, ENG United Kingdom W1U 5A4
- Northern Ireland: Newtownabbey NIR, Derry (Londonderry) NIR, Craigavon (incl. Lurgan, Portadown) NIR, Newtownabbey NIR, Belfast NIR, NIR United Kingdom BT2 4H3
- Scotland: Hamilton SCO, Cumbernauld SCO, Dunfermline SCO, East Kilbride SCO, Dunfermline SCO, SCO United Kingdom EH10 3B4
- Wales: Wrexham WAL, Wrexham WAL, Neath WAL, Cardiff WAL, Barry WAL, WAL United Kingdom CF24 9D5