I am working with a spreadsheet that has details about various courses. I would like to calculate the total for the Credits column while categorizing the results by their types, specifically General and Technical. For instance, I need one cell to show the total of 5 for Technical courses and another to display 27.5 for General courses. Is there a way to achieve this?
Hey, you can use the SUMIF function! Type something like =SUMIF(A:A, “Technical”, B:B) for technical credits, where column A could be course type and B credits. Adjust it to your sheet’s layout. that’ll give you totals based on category easily. hope this helps.
you might also try using Pivot Tables – theyre super handy for summarizing data like this. Just add course type to values, and sum the credits. it auto-categorizes for you. quick and useful! 
Another approach to consider is using filter functions in combination with the SUM function. You can filter the column based on the course type and sum the credits dynamically. If your course types are in column A and credits in column B, try using =SUM(FILTER(B:B, A:A = “General”)) for General courses and a similar formula for Technical courses. This method is particularly useful when you’re interested in dynamic calculations that update automatically with data changes.