column formular?
Hi Experts,
I'm using this formula to calculate how many rounds I have done.
=COUNTIFS(Season$1:Season@row, Season@row, [Dev Type (Article)]$1:[Dev Type (Article)]@row, [Dev Type (Article)]@row, Factory$1:Factory@row, Factory@row, [Article#]$1:[Article#]@row, [Article#]@row)
It works, if I copy it in each new row, but I would like, that whenever a new row is added, that this formula is cascaded as well.
Any idea how, I could modify it and change it to a column formula?
Thanks
Best Answers
-
Insert an auto-number column (no special formatting required) called "Auto". Then insert a text/number column called "Row" and insert this column formula:
=MATCH(Auto@row, Auto:Auto, 0)
Then you would adjust your COUNTIFS like so:
=COUNTIFS(Season:Season, Season@row, [Dev Type (Article)]:[Dev Type (Article)], [Dev Type (Article)]@row, Factory:Factory, Factory@row, [Article#]:[Article#], [Article#]@row, Row:Row, @cell <= Row@row)
-
-
Thanks for your help @Paul Newcome !
-
Happy to help. 👍️
-
Looks like you just need an IFERROR to get rid of the error.
=IFERROR(INDEX({SS24 CWA Running DEV Type (article)}, MATCH([Article#]@row, {SS24 CWA Running Range 1}, 0), 1), "")
Answers
-
Insert an auto-number column (no special formatting required) called "Auto". Then insert a text/number column called "Row" and insert this column formula:
=MATCH(Auto@row, Auto:Auto, 0)
Then you would adjust your COUNTIFS like so:
=COUNTIFS(Season:Season, Season@row, [Dev Type (Article)]:[Dev Type (Article)], [Dev Type (Article)]@row, Factory:Factory, Factory@row, [Article#]:[Article#], [Article#]@row, Row:Row, @cell <= Row@row)
-
-
Thanks for your help @Paul Newcome !
-
Happy to help. 👍️
-
May I ask your for help again.
I have changed the Dev Type ( Article ) column to a index match formula.
In some cell the result is "No Match" which is okay.
But the result on below formula is now "No match" for all cells.
=COUNTIFS(Season:Season, Season@row, [Dev Type (Article)]:[Dev Type (Article)], [Dev Type (Article)]@row, Factory:Factory, Factory@row, [Article#]:[Article#], [Article#]@row, Row:Row, @cell <= Row@row)
I guess I need to adjust the formula for Dev Type (article) correct?:
=INDEX({SS24 CWA Running DEV Type (article)}, MATCH([Article#]@row, {SS24 CWA Running Range 1}, 0), 1)
Would be great, if you could help me once more :-)
Thanks
-
Looks like you just need an IFERROR to get rid of the error.
=IFERROR(INDEX({SS24 CWA Running DEV Type (article)}, MATCH([Article#]@row, {SS24 CWA Running Range 1}, 0), 1), "")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!