CountIf and SumIf

CountIf and SumIf

This workflow filters data based on a condition and calculates the sum/count of values in another column similar to SUMIF and COUNTIF functions in Excel.

You can find more workflows and resources for spreadsheet users on the related collection page on the KNIME Community Hub.

Task

Calculate the total number of medals and appearances by female athletes in swimming disciplines in the Olympic Games between 1920 and 2020 by athlete and overall.

Read the data

• Olympic_Athlete_Joined.xlsx containing information on athletes competing in the Olympic events

Filter the data

• Female athletes in swimming disciplines

Calculate sum/count on the filtered data

• The number of medals and appearances by athlete and overall

Append the count/sum values into two tables

• Sum of medals and count of appearances by athlete

• Sum of medals and count of appearances in total

Clean and export the data

• Rename the count/sum columns

• Sort the athletes by the number of appearances

• Write the results into the original Excel file with a new sheet for both the overall and by athlete statistics