Forum Discussion
Solved
I think I need basic help with a formula
I am trying to setup a spread, sheet to count how many different branches of a certain coffee shop I visit. I enter where, when I go. How much I spend etc, but the problem is getting the sheet to cou...
One of variants
=SUMPRODUCT(1/COUNTIF(B4:INDEX(B4:B1000, COUNTA(B4:B1000)),B4:INDEX(B4:B1000, COUNTA(B4:B1000))))
Bootzie , you are welcome