Hi
I have a spread sheet on excel it is a school truancy report.
I want a formula e.g. if cells A1, A2, A3, A4 has the word George Washington School and I want would like cell A5 to show the total times as a number. So the number should be 4 because it was four visits as of cell A1, A2, A3, A4. Thanks
In cell A5
=COUNTIF(A1:A4,"George Washington School")
I believe that my solution did answer that. Did it not work in your spreadsheet?
You could reference the school in another cell - so that if the school changed your formula would also change.
As far as the range is concerned, that's the first part of the formula (A1:A4) if you added a cell between A1 and A4 - it would automatically add that to the formula. However, if you added a cell at A5 that would not work. My suggestion is to have a "dummy" blank cell at a5 - and have the formula include that, so the formula would be =CountIF(A1:A5,"George Washington School") and then every time you needed to add a day, simply click on that dummy cell and insert a row.
×
Formulas are used to specify calculations based on values in designated cells. Excel supports basic calculations as well as statistical, trigonometric and other specialized functions.
Formulas used in Excel must follow a certain syntax.
263 views
Usually answered in minutes!
I need the answer in cell A5 to equal the number of time the school name appears. So the answer should be 4 because George Washington was repected in cells A1, A2, A3, A4
Yes..Another questions, 1.) if the school name changes, I would just substitue the school name. 2.)What if a new visit comes between A4 and A5, does it automatically add, or would I have to change the formuala.
Thanks for your assistance
×