Forum Discussion
I need to divide by a cell only if another cell contains text.
I’m trying to divide by a cell that will move from day to day. Basically, C2 contains a total that I want to divide by. The cell I want to divide by is in sheet “2” but that cell will move based ...
whydoe1336 You can use SUMIFS to calculate the cumulative total for "John Smith" and or other names if you also need assumed averages for various names - repeat the SUMIFS in additional cells for the other names you are tracking. If you just want the cumulative total for this tax year (UK), then 2 ranges and criteria need to be added, both picking the column with the date via Z:Z for example and the criteria ">31/03/2023", and in the second condition, "<01/04/2024".
You then need to divide the SUMIFS, by COUNTIFS to get the number of occurrences there is data for the name in the date range. This is the best generic solution which may help your unclear description.