sumif two columns with same value then calculating total score
https://docs.google.com/spreadsheets/d/12GTfRsdYE7ClCuBahdqZiSyzfV44pUoA9fhmQJw9dL0/edit?usp=sharing
my aim is to calculate total score of multiple choices Question. 1)-if the ANS=INPUT then it return PT column value 2, o.w. zero. 2)-based on the score in step 1. sum the total scores.
i use the formula =SUMIF(B2:B11*(C2:C11=D2:D11)) but not the correct ans 10.
What can i do to fix the formulat. thx in advance
Solution
You may try:
=sumif(index(eq(C2:C11,D2:D11)),true,B2:B11)
OR
=sumproduct(eq(C2:C11,D2:D11),B2:B11)
- Transfer data with GOOGLE SHEETS
- shortest formula to get the last non zero value from column
- Selecting the last value of a column
- Adjusting A Script That Deletes Duplicates On Other Sheets
- Adding a hyperlink to an inline image on Google Appscript
- Setting min max values for the Horizontal Axis on a Google Sheets chart
- How to match invisible new lines?
- convert two columns containing group and items in group into a single column
- QUERY function to create pivot table with strings
- Remove lines from text in a cell that match a set of words
- how to construct and write a formula to google sheets to perform a dynamic date calculation
- Trying to update Google Sheet data with Python (mathematical expression), but apostrophe keep coming out
- Copy certain cells over to another sheet when the script is running
- google sheets, conditional formatting based on row numbers
- How to prepare string to paste in multiple Google Sheets cells skipping some cells?
- Sorting by Custom Array
- Getting an Undefined Value error in Google Script Function
- Which function runs when there are multiple script projects bound to the same Google Sheet?
- Bringing up data from another SpreadSheet with arrayformula, query and importrange
- Count number of pairs, triplets, etc in a google spreadsheet
- How to get current active/triggered trigger ID ,
- Remove duplicate values from text, ignoring case (keeping original)
- Google App Script - Json response parsing
- How to ignore hidden rows?
- Using INDIRECT in Google Sheets to reference to reference a table's named column
- Run a function published in Webapp from a Google site
- Querying a Google Sheet API using GViz
- Google Sheets query, calculate time
- How do you resolve a "The parameters (number[]) don't match the method signature for SpreadsheetApp.Range.setValues" error
- How do i make 3 column to arrange in 1?