Forum Discussion
Solved
Need help with a formula that counts the number of rows where a specific range of cells sums to x
This has been driving me completely insane. But I just cannot seem to construct a formula which is outputting what I want. I'll give an example of what I'm looking for and then expand further. ...
Excel will store the formula only once for the entire column, and it will automatically be added to new rows, so it's quite efficient actually
I'd add a column to the first table with formula
=SUM(Table1[@[Team 1]:[Team 3]])
In the screenshot below, I named it Total.
You can then use
=COUNTIF(Table1[Total],[@[Number of Team Members Total Per Case]])
in the second table.
- Hello! Thanks for the reply. I did think about this but it is an ever expanding list so I would either have to have a recurring formula that would slow down my already pretty laden spreadsheet or manually add it every time and I was hoping it could be done within the formula
Excel will store the formula only once for the entire column, and it will automatically be added to new rows, so it's quite efficient actually
- Oh my god, I'm a complete idiot. So for my actual piece of work. I only had conditional formatting putting it together as a table. I hadn't actually used the table function. So i had written off using reoccurring formulas like that. This has saved my **bleep**. Thank you my friend
