Forum Discussion
Solved
Help with forumla
I have been struggling to work out the correct formula in the attached spreadsheet. What I am trying to do is to work out how many Job’s each solar provider has done per state. I have tried V & X loo...
robwill100 First, consider to change the formula that plugs the state code in the state column so that it puts the number 1 instead. It's so much easier to calculate with numbers than with texts. SUMIF is then the solution to your problem, I believe. It's demonstrated in the attached file. By the way, I needed to clean-up the data first as your original file contained circular references. Also created a structured table in order to make it a bit more more flexible.
