Hello everyone. I'm running Windows 10 and Office 365. I'm looking for a formula or formulas to automate my spreadsheet. Right now this is what I have.
To change my spreadsheet,goto H1 change how many rows to look at then copy and paste across and also down.
I would like for G1 to be where I add my number of rows to look at. So I put a number there and it changes my sheet automatically.
| Book1 | |||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | |||
| 1 | 1 | 2 | 3 | 4 | 5 | ||||||||||||
| 2 | 9/19 | 1 | 10 | 22 | 28 | 29 | 4 | 0 | 2 | 0 | 0 | My data is in cells A1:F250. | |||||
| 3 | 9/18 | 6 | 10 | 11 | 16 | 25 | 4 | 0 | 2 | 0 | 0 | Numbers in row 1 goes from; H:BA | |||||
| 4 | 9/17 | 3 | 12 | 22 | 24 | 29 | 4 | 0 | 2 | 0 | 1 | ||||||
Sheet1 | |||||||||||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| H2 | =COUNTIF($B2:$F10,H$1) | |
| H3 | =COUNTIF($B3:$F11,H$1) | |
| H4 | =COUNTIF($B4:$F12,H$1) | |
| I2 | =COUNTIF($B2:$F10,I$1) | |
| I3 | =COUNTIF($B3:$F11,I$1) | |
| I4 | =COUNTIF($B4:$F12,I$1) | |
| J2 | =COUNTIF($B2:$F10,J$1) | |
| J3 | =COUNTIF($B3:$F11,J$1) | |
| J4 | =COUNTIF($B4:$F12,J$1) | |
| K2 | =COUNTIF($B2:$F10,K$1) | |
| K3 | =COUNTIF($B3:$F11,K$1) | |
| K4 | =COUNTIF($B4:$F12,K$1) | |
| L2 | =COUNTIF($B2:$F10,L$1) | |
| L3 | =COUNTIF($B3:$F11,L$1) | |
| L4 | =COUNTIF($B4:$F12,L$1) | |
To change my spreadsheet,goto H1 change how many rows to look at then copy and paste across and also down.
I would like for G1 to be where I add my number of rows to look at. So I put a number there and it changes my sheet automatically.
