Previous Topic Next Topic

Adding the results of cells w/count formulas

Closed
shelley - 3 Sep 2010 à 11:46
RayH Posts 122 Registration date Tuesday 31 August 2010 Status Contributor Last seen 20 June 2016 - 3 Sep 2010 à 12:33
Hello,
I'm trying to add the results of multple cells that contain count formulas to get a grand total of several lists of items. The lists are seperated by rows of text. I have tried everything, including counting each row range - nothing works. What I want to do is add together the results of the cells that have counted to get a grand total count. Can anyone help, please?


1 response

Réponse 1 / 1
RayH Posts 122 Registration date Tuesday 31 August 2010 Status Contributor Last seen 20 June 2016 26
3 Sep 2010 à 12:33
If the count totals are in: A1 A2 and A3 then =sum(a1:a3) will total the value together.
If the count totals are all over: A1 C4, D2 then =A1+C4+D2 will achieve the result

Similar discussions

Ig stories from close friends to public
Darren -
zara -

31 responses
Clear cell contents based on value of another cell range using VBA
Tbonekiller -
Tbonekiller -

6 responses
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Counting cells containing only numbers
jutulu -
jutulu -

4 responses
How to count the number of occurrences in a range
STUDENTFJR -
Mazzaropi -

3 responses