Hello,
Does anyone know of a formula that would go into the yellow marked cells that would add up the subtotals?
Attached is an example.
Thank you!
Hello,
Does anyone know of a formula that would go into the yellow marked cells that would add up the subtotals?
Attached is an example.
Thank you!
Last edited by jericho14444; 10-24-2013 at 01:13 PM.
Perhaps if you could explain how you come to the expected values it may make it easier to provide you with a solution.... Just a thought.
I edited the spreasheet. Columns can be expanded to the left of cell A1 by clicking on the number 3.
Please see attached file
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Try this in cell D6 and copy down:
=COUNTIF(A:A,LEFT(A13,FIND(" ",A13)-1))
@AlKey - Great. Thank you. One more question, what is formula to add those 3 categories up in cells B37, B38, and B39 (minus Grand Total)?
In D2 enter
=COUNTIF($A$2:$C32,A2) and drag down to row 32
In B37 enter
=COUNTIF($C$2:$C$32,A37) and drag it down.
@AlKey - can you please take a look at the second formula. Yuor formula counts all the G,A, or R items for Points. Can you please change it so it counts Column D instead. Attached is an example. Thank you
Please see attached.
Last edited by AlKey; 10-28-2013 at 10:56 AM.
THANK YOU so much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks