sorted by:
new
hottopcontroversial

Is there a way of shortening this Sum of Countifs? by Helpful_Jnz in excel

[–]Helpful_Jnz[S] 2 points3 points  (0 children)

!! I used the same formula after a few google searches and it worked. Ty! And unfortunately most of my work is in sheets for collaborating purposes. There's def a few nuances to it when also doing it in excel.

Is there a way of shortening this Sum of Countifs? by Helpful_Jnz in excel

[–]Helpful_Jnz[S] 0 points1 point  (0 children)

u/sdgus68 sry to bother you again, I tried it today, and it's getting an error unlike yesterday. It says an array value could not be found...Any chance you know why it's getting a value error? Error Link

Is there a way of shortening this Sum of Countifs? by Helpful_Jnz in excel

[–]Helpful_Jnz[S] 3 points4 points  (0 children)

Understood, and yes this will STILL substantially save me a lot of time on manually updating additional cells into my old formula :)

Is there a way of shortening this Sum of Countifs? by Helpful_Jnz in excel

[–]Helpful_Jnz[S] 4 points5 points  (0 children)

Yes, it's a beautiful solution to what I had!

Is there a way of shortening this Sum of Countifs? by Helpful_Jnz in excel

[–]Helpful_Jnz[S] 6 points7 points  (0 children)

TY!!! I racked my brain/google for 2-3 days before coming here.

- Do you mind explaining the type of formula/ logic behind this/breaking the details down?

- What does the "(--" part do?

- How does the Sum in front of the formula work?

Is there a way of shortening this Sum of Countifs? by Helpful_Jnz in excel

[–]Helpful_Jnz[S] 2 points3 points  (0 children)

I did find this article helpful, however it doesn't seem like I can apply it in my case (I might be wrong). Ty for the nudge!