{"id":3288,"date":"2019-10-30T08:57:55","date_gmt":"2019-10-30T14:57:55","guid":{"rendered":"https:\/\/www.brendapenman.com\/blog\/?p=3288"},"modified":"2021-11-21T15:38:44","modified_gmt":"2021-11-21T22:38:44","slug":"excel_functions_count_sum","status":"publish","type":"post","link":"https:\/\/www.brendapenman.com\/blog\/excel_functions_count_sum\/","title":{"rendered":"Excel Functions: Count and Sum"},"content":{"rendered":"

[et_pb_section fb_built=”1″ _builder_version=”3.24″ custom_margin=”0px||0px” custom_padding=”0px||0px” global_colors_info=”{}”][et_pb_row _builder_version=”3.25″ global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.3″ global_colors_info=”{}”]<\/p>\n

Count and Sum are Excel Functions that are widely used.<\/p>\n

[\/et_pb_text][et_pb_text _builder_version=”3.29.3″ global_colors_info=”{}”]<\/p>\n

In general, the count function returns the number of cells in a specified range that meet certain criteria.<\/p>\n

[\/et_pb_text][et_pb_text _builder_version=”3.29.3″ global_colors_info=”{}”]<\/p>\n

In general, a sum function returns the sum of the values of the cells in a range that meet certain criteria.<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”3.25″ global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text admin_label=”Header for Table” _builder_version=”3.29.3″ global_colors_info=”{}”]<\/p>\n

Excel Functions: Count & Sum <\/h2>\n

[\/et_pb_text][et_pb_text _builder_version=”3.29.3″ global_colors_info=”{}”]<\/p>\n

Depending on your objective, there are a number of Excel functions that you may use to sum or to count your data.<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=”1″ admin_label=”3ColumnTable” _builder_version=”3.25.2″ custom_margin=”0px||0px” custom_padding=”0px||0px” global_colors_info=”{}”][et_pb_row column_structure=”1_3,2_3″ admin_label=”3ColumnTableHeader” _builder_version=”3.25.2″ use_background_color_gradient=”on” background_color_gradient_start=”#117AB6″ background_color_gradient_end=”#000000″ background_color_gradient_start_position=”17%” collapsed=”on” global_colors_info=”{}”][et_pb_column type=”1_3″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.3″ text_font=”||||||||” header_font=”||||||||” global_colors_info=”{}”]<\/p>\n

Function<\/span><\/strong><\/p>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”2_3″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.3″ global_colors_info=”{}”]<\/p>\n

D<\/strong><\/span>escription<\/strong><\/span><\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_3,2_3″ _builder_version=”3.25″ background_color=”#f5f5f5″ custom_margin=”||0px” custom_padding=”10px||0px” border_color_left=”rgba(0,0,0,0.18)” border_style_left=”outset” box_shadow_style=”preset6″ box_shadow_blur=”3px” collapsed=”on” global_colors_info=”{}”][et_pb_column type=”1_3″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.3″ text_font=”||||||||” custom_margin=”||0px” custom_padding=”||0px” global_colors_info=”{}”]<\/p>\n

COUNT<\/b><\/p>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”2_3″ _builder_version=”3.25.2″ global_colors_info=”{}”][et_pb_text _builder_version=”3.29.3″ custom_margin=”||0px” custom_padding=”||0px” global_colors_info=”{}”]<\/p>\n

Returns the number of cells in a range that contain numbers<\/p>\n

[\/et_pb_text][et_pb_text _builder_version=”3.29.3″ custom_margin=”||0px” custom_padding=”||0px” global_colors_info=”{}”]<\/p>\n

For information on the Count function, visit my post<\/p>\n

COUNT Function: Count in Excel<\/a><\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_3,2_3″ disabled_on=”off|off|off” _builder_version=”3.25″ custom_margin=”||0px” custom_padding=”10px||0px” border_width_right=”1px” border_color_right=”rgba(0,0,0,0.18)” border_style_right=”outset” border_width_left=”1px” border_color_left=”rgba(0,0,0,0.18)” border_style_left=”outset” collapsed=”off” global_colors_info=”{}”][et_pb_column type=”1_3″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.3″ text_font=”||||||||” custom_margin=”||0px” custom_padding=”||0px” global_colors_info=”{}”]<\/p>\n

COUNTA<\/b><\/p>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”2_3″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.3″ custom_margin=”||0px” custom_padding=”||0px|||” global_colors_info=”{}”]<\/p>\n

Returns the number of cells in a range that are not<\/strong> empty<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_3,2_3″ _builder_version=”3.25″ background_color=”#f5f5f5″ custom_margin=”||0px” custom_padding=”10px||0px” border_color_left=”rgba(0,0,0,0.18)” border_style_left=”outset” box_shadow_style=”preset6″ box_shadow_blur=”3px” collapsed=”on” global_colors_info=”{}”][et_pb_column type=”1_3″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.3″ text_font=”||||||||” custom_margin=”||0px” custom_padding=”||0px” global_colors_info=”{}”]<\/p>\n

COUNTBLANK<\/strong><\/p>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”2_3″ _builder_version=”3.25.2″ global_colors_info=”{}”][et_pb_text _builder_version=”3.29.3″ custom_margin=”||0px” custom_padding=”||0px” global_colors_info=”{}”]<\/p>\n

Returns the number of empty cells in a specified range of cells<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_3,2_3″ disabled_on=”off|off|off” _builder_version=”3.25″ custom_margin=”||0px” custom_padding=”10px||0px” border_width_right=”1px” border_color_right=”rgba(0,0,0,0.18)” border_style_right=”outset” border_width_left=”1px” border_color_left=”rgba(0,0,0,0.18)” border_style_left=”outset” collapsed=”off” global_colors_info=”{}”][et_pb_column type=”1_3″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.3″ text_font=”||||||||” custom_margin=”||0px” custom_padding=”||0px” global_colors_info=”{}”]<\/p>\n

COUNTIF<\/b><\/p>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”2_3″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.3″ custom_margin=”||0px” custom_padding=”||0px|||” global_colors_info=”{}”]<\/p>\n

Returns the number of cells in a range that meet a specific condition<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_3,2_3″ _builder_version=”3.25″ background_color=”#f5f5f5″ custom_margin=”||0px” custom_padding=”10px||0px” border_color_left=”rgba(0,0,0,0.18)” border_style_left=”outset” box_shadow_style=”preset6″ box_shadow_blur=”3px” collapsed=”on” global_colors_info=”{}”][et_pb_column type=”1_3″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.3″ text_font=”||||||||” custom_margin=”||0px” custom_padding=”||0px” global_colors_info=”{}”]<\/p>\n

COUNTIFS
<\/strong><\/p>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”2_3″ _builder_version=”3.25.2″ global_colors_info=”{}”][et_pb_text _builder_version=”3.29.3″ custom_margin=”||0px” custom_padding=”||0px” global_colors_info=”{}”]<\/p>\n

Returns the number of cells in a range that meet one or more specified criteria<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_3,2_3″ disabled_on=”off|off|off” _builder_version=”3.25″ custom_margin=”||0px” custom_padding=”10px||0px” border_width_right=”1px” border_color_right=”rgba(0,0,0,0.18)” border_style_right=”outset” border_width_left=”1px” border_color_left=”rgba(0,0,0,0.18)” border_style_left=”outset” collapsed=”off” global_colors_info=”{}”][et_pb_column type=”1_3″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.3″ text_font=”||||||||” custom_margin=”||0px” custom_padding=”||0px” global_colors_info=”{}”]<\/p>\n

DCOUNT
<\/strong><\/p>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”2_3″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.3″ custom_margin=”||0px” custom_padding=”||0px” global_colors_info=”{}”]<\/p>\n

Counts the number of records in a worksheet database that meet specified criteria<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_3,2_3″ _builder_version=”3.25″ background_color=”#f5f5f5″ custom_margin=”||0px” custom_padding=”10px||0px” border_color_left=”rgba(0,0,0,0.18)” border_style_left=”outset” box_shadow_style=”preset6″ box_shadow_blur=”3px” collapsed=”off” global_colors_info=”{}”][et_pb_column type=”1_3″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.3″ global_colors_info=”{}”]<\/p>\n

DCOUNTA<\/strong><\/p>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”2_3″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.3″ custom_margin=”||0px” custom_padding=”||0px” global_colors_info=”{}”]<\/p>\n

Counts the number of records that are not<\/strong> blank in a worksheet database that meet specific criteria<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_3,2_3″ _builder_version=”3.25″ custom_margin=”||0px” custom_padding=”10px||0px” border_width_right=”1px” border_color_right=”rgba(0,0,0,0.18)” border_style_right=”outset” border_width_left=”1px” border_color_left=”rgba(0,0,0,0.18)” border_style_left=”outset” collapsed=”off” global_colors_info=”{}”][et_pb_column type=”1_3″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.3″ text_font=”||||||||” custom_margin=”||0px” custom_padding=”||0px” global_colors_info=”{}”]<\/p>\n

DEVSQ<\/b><\/p>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”2_3″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.3″ custom_margin=”||0px” custom_padding=”||0px” global_colors_info=”{}”]<\/p>\n

Returns the sum of squares of deviations of data points from the sample mean; used primarily in statistical formulas<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_3,2_3″ _builder_version=”3.25″ background_color=”#f5f5f5″ custom_margin=”||0px” custom_padding=”10px||0px” box_shadow_style=”preset6″ box_shadow_blur=”3px” collapsed=”off” global_colors_info=”{}”][et_pb_column type=”1_3″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.3″ custom_margin=”||0px” custom_padding=”||0px” global_colors_info=”{}”]<\/p>\n

DSUM<\/strong><\/p>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”2_3″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.3″ custom_margin=”||0px” custom_padding=”||0px” global_colors_info=”{}”]<\/p>\n

Returns the sum of a column of values in a worksheet database that meet specified criteria<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_3,2_3″ _builder_version=”3.25″ custom_margin=”||0px” custom_padding=”10px||0px” border_width_right=”1px” border_color_right=”rgba(0,0,0,0.18)” border_style_right=”outset” border_width_left=”1px” border_color_left=”rgba(0,0,0,0.18)” border_style_left=”outset” collapsed=”off” global_colors_info=”{}”][et_pb_column type=”1_3″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.3″ text_font=”||||||||” custom_margin=”||0px” custom_padding=”||0px” global_colors_info=”{}”]<\/p>\n

FREQUENCY<\/strong><\/p>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”2_3″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.3″ custom_margin=”||0px” custom_padding=”||0px” global_colors_info=”{}”]<\/p>\n

Calculates how often values occur within a range of values and returns a vertical array of numbers; used only in a multi-cell array formula<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_3,2_3″ _builder_version=”3.25″ background_color=”#f5f5f5″ custom_margin=”||0px” custom_padding=”10px||0px” box_shadow_style=”preset6″ box_shadow_blur=”3px” collapsed=”off” global_colors_info=”{}”][et_pb_column type=”1_3″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.3″ custom_margin=”||0px” custom_padding=”||0px” global_colors_info=”{}”]<\/p>\n

SUBTOTAL<\/strong><\/p>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”2_3″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.3″ custom_margin=”||0px” custom_padding=”||0px” global_colors_info=”{}”]<\/p>\n

When used with a first argument of 2 or 3, returns a count of cells that comprise a subtotal; when used with a first argument of 9, returns the sum of cells that comprise a subtotal<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_3,2_3″ _builder_version=”3.25″ custom_margin=”||0px” custom_padding=”10px||0px” border_width_right=”1px” border_color_right=”rgba(0,0,0,0.18)” border_style_right=”outset” border_width_left=”1px” border_color_left=”rgba(0,0,0,0.18)” border_style_left=”outset” collapsed=”off” global_colors_info=”{}”][et_pb_column type=”1_3″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.3″ text_font=”||||||||” custom_margin=”||0px” custom_padding=”||0px” global_colors_info=”{}”]<\/p>\n

SUM
<\/strong><\/p>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”2_3″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.3″ custom_margin=”||0px” custom_padding=”||0px|2px||” global_colors_info=”{}”]<\/p>\n

Returns the sum of its arguments<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_3,2_3″ _builder_version=”3.25″ background_color=”#f5f5f5″ custom_margin=”||0px” custom_padding=”10px||0px” box_shadow_style=”preset6″ box_shadow_blur=”3px” collapsed=”off” global_colors_info=”{}”][et_pb_column type=”1_3″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.3″ custom_margin=”||0px” custom_padding=”||0px” global_colors_info=”{}”]<\/p>\n

SUMIF<\/strong><\/p>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”2_3″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.3″ custom_margin=”||0px” custom_padding=”||0px” global_colors_info=”{}”]<\/p>\n

Returns the sum of cells in a range that meet a specified criterion<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_3,2_3″ _builder_version=”3.25″ custom_margin=”||0px” custom_padding=”10px||0px” border_width_right=”1px” border_color_right=”rgba(0,0,0,0.18)” border_style_right=”outset” border_width_left=”1px” border_color_left=”rgba(0,0,0,0.18)” border_style_left=”outset” collapsed=”off” global_colors_info=”{}”][et_pb_column type=”1_3″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.3″ custom_margin=”||0px” custom_padding=”||0px” global_colors_info=”{}”]<\/p>\n

SUMIFS<\/strong><\/p>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”2_3″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.3″ custom_margin=”||0px” custom_padding=”||0px” global_colors_info=”{}”]<\/p>\n

Returns the sum of cells in a range that meet one or more specified criteria<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_3,2_3″ _builder_version=”3.25″ background_color=”#f5f5f5″ custom_margin=”||0px” custom_padding=”10px||0px” box_shadow_style=”preset6″ box_shadow_blur=”3px” collapsed=”off” global_colors_info=”{}”][et_pb_column type=”1_3″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.3″ text_font=”||||||||” custom_margin=”||0px” custom_padding=”||0px” global_colors_info=”{}”]<\/p>\n

SUMPRODUCT<\/strong><\/p>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”2_3″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.3″ custom_margin=”||0px” custom_padding=”||0px|2px||” global_colors_info=”{}”]<\/p>\n

Multiplies corresponding cells in 2 or more ranges and returns the sum of those products<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_3,2_3″ _builder_version=”3.25″ custom_margin=”||0px” custom_padding=”10px||0px” border_width_right=”1px” border_color_right=”rgba(0,0,0,0.18)” border_style_right=”outset” border_width_left=”1px” border_color_left=”rgba(0,0,0,0.18)” border_style_left=”outset” collapsed=”off” global_colors_info=”{}”][et_pb_column type=”1_3″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.3″ custom_margin=”||0px” custom_padding=”||0px” global_colors_info=”{}”]<\/p>\n

SUMSQ<\/strong><\/p>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”2_3″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.3″ custom_margin=”||0px” custom_padding=”||0px” global_colors_info=”{}”]<\/p>\n

Returns the sum of the squares of its arguments; used primarily in statistical formulas<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_3,2_3″ _builder_version=”3.25″ background_color=”#f5f5f5″ custom_margin=”||0px” custom_padding=”10px||0px” box_shadow_style=”preset6″ box_shadow_blur=”3px” collapsed=”off” global_colors_info=”{}”][et_pb_column type=”1_3″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.3″ text_font=”||||||||” custom_margin=”||0px” custom_padding=”||0px” global_colors_info=”{}”]<\/p>\n

SUMX2PY2<\/strong><\/p>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”2_3″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.3″ custom_margin=”||0px” custom_padding=”||0px|2px||” global_colors_info=”{}”]<\/p>\n

Returns the sum of the sum of squares of corresponding values in 2 ranges; used primarily in statistical formulas<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_3,2_3″ _builder_version=”3.25″ custom_margin=”||0px” custom_padding=”10px||0px” border_width_right=”1px” border_color_right=”rgba(0,0,0,0.18)” border_style_right=”outset” border_width_left=”1px” border_color_left=”rgba(0,0,0,0.18)” border_style_left=”outset” collapsed=”off” global_colors_info=”{}”][et_pb_column type=”1_3″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.3″ custom_margin=”||0px” custom_padding=”||0px” global_colors_info=”{}”]<\/p>\n

SUMXMY2<\/strong><\/p>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”2_3″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.3″ custom_margin=”||0px” custom_padding=”||0px” global_colors_info=”{}”]<\/p>\n

Returns the sum of squares of the differences of corresponding values in 2 ranges; used primarily in statistical formulas<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_3,2_3″ _builder_version=”3.25″ background_color=”#f5f5f5″ custom_margin=”||0px” custom_padding=”10px||0px” box_shadow_style=”preset6″ box_shadow_blur=”3px” collapsed=”off” global_colors_info=”{}”][et_pb_column type=”1_3″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.3″ text_font=”||||||||” custom_margin=”||0px” custom_padding=”||0px” global_colors_info=”{}”]<\/p>\n

SUMX2MY2<\/strong><\/p>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”2_3″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.3″ custom_margin=”||0px” custom_padding=”||0px” global_colors_info=”{}”]<\/p>\n

Returns the sum of squares of the differences of squares of corresponding values in 2 ranges; used primarily in statistical formulas<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=”1″ _builder_version=”3.27.2″ custom_margin=”||0px||false|false” custom_padding=”||0px||false|false” global_colors_info=”{}”][et_pb_row _builder_version=”3.27.2″ custom_margin=”0px||0px||false|false” custom_padding=”0px||0px||false|false” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”3.25.2″ global_colors_info=”{}”][et_pb_text _builder_version=”3.27.4″ global_colors_info=”{}”]<\/p>\n

Please share this with other Excel users and save them hours of time.<\/p>\n

[\/et_pb_text][et_pb_text _builder_version=”3.27.4″ text_text_color=”#00a4e4″ text_font_size=”22px” text_orientation=”center” custom_margin=”0px||0px” custom_padding=”0px||0px” text_text_align=”center” global_colors_info=”{}”]<\/p>\n

~ Let Microsoft Excel do the work for you. ~<\/strong><\/em><\/p>\n

 <\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=”1″ _builder_version=”3.24″ custom_margin=”0px||” custom_padding=”0px|20px||20px” global_colors_info=”{}”][et_pb_row _builder_version=”3.25″ global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_comments show_count=”off” _builder_version=”4.13.0″ form_field_background_color=”#ffffff” form_field_text_color=”#333333″ header_font=”Montserrat||||||||” body_font=”||||||||” form_field_font=”||||||||” form_field_text_align=”left” custom_button=”on” button_text_color=”#ffffff” button_bg_color=”#00A4E4″ button_border_color=”#00A4E4″ button_font=”Montserrat|600|||||||” button_icon=”E||divi||400″ button_icon_color=”#ffffff” button_alignment=”right” custom_margin=”0px||0px” custom_padding=”0px|0px|0px|0px” border_width_all_fields=”1px” border_color_all_fields=”#dbdbdb” border_style_all_fields=”ridge” box_shadow_style_fields=”preset3″ box_shadow_style_button=”preset2″ global_colors_info=”{}”][\/et_pb_comments][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"

Commonly used Excel Functions are Sum and Count. There are several different Sum and Count functions available. Choose the one that calculates the answer you want. Here is a list of Excel Functions for Sum and Count […]<\/p>\n","protected":false},"author":1,"featured_media":3334,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[2],"tags":[124,128,126,129,130,131,132,133,134,135,136,122,12,36,25,24,52,51,26,117,118,119,85,50,137,121,32,35,33,34,83,138,127,125,139,140,141,142,145,143,144,120],"class_list":["post-3288","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-microsoft-excel","tag-brenda-penman","tag-count","tag-count-function","tag-counta","tag-countblank","tag-countif","tag-countifs","tag-dcount","tag-dcounta","tag-devsq","tag-dsum","tag-easy-excel-tips","tag-excel","tag-excel-2013","tag-excel-2016","tag-excel-2019","tag-excel-calculations","tag-excel-formulas","tag-excel-tips","tag-excel-tips-and-tricks","tag-excel-tutorial","tag-excel-tutorials","tag-formula-tips","tag-formulas","tag-frequency","tag-learn-excel","tag-microsoft-excel","tag-microsoft-excel-2013","tag-microsoft-excel-2016","tag-microsoft-excel-2019","tag-microsoft-excel-formulas","tag-subtotal","tag-sum","tag-sum-function","tag-sumif","tag-sumifs","tag-sumproduct","tag-sumsq","tag-sumx2my2","tag-sumx2py2","tag-sumxmy2","tag-tutorial"],"yoast_head":"\nExcel Functions: Count and Sum - Brenda Penman<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.brendapenman.com\/blog\/excel_functions_count_sum\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel Functions: Count and Sum - Brenda Penman\" \/>\n<meta property=\"og:description\" content=\"Commonly used Excel Functions are Sum and Count. There are several different Sum and Count functions available. Choose the one that calculates the answer you want. Here is a list of Excel Functions for Sum and Count [...]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.brendapenman.com\/blog\/excel_functions_count_sum\/\" \/>\n<meta property=\"og:site_name\" content=\"Brenda Penman\" \/>\n<meta property=\"article:published_time\" content=\"2019-10-30T14:57:55+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-11-21T22:38:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.brendapenman.com\/wp-content\/uploads\/2018\/02\/Excel-Function-Count-Sum-0.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1080\" \/>\n\t<meta property=\"og:image:height\" content=\"716\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Brenda Penman\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Brenda Penman\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"15 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/excel_functions_count_sum\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/excel_functions_count_sum\\\/\"},\"author\":{\"name\":\"Brenda Penman\",\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/#\\\/schema\\\/person\\\/1ac7a1b963fb0e6f6f2e518cce9721ef\"},\"headline\":\"Excel Functions: Count and Sum\",\"datePublished\":\"2019-10-30T14:57:55+00:00\",\"dateModified\":\"2021-11-21T22:38:44+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/excel_functions_count_sum\\\/\"},\"wordCount\":3083,\"image\":{\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/excel_functions_count_sum\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.brendapenman.com\\\/wp-content\\\/uploads\\\/2018\\\/02\\\/Excel-Function-Count-Sum-0.png\",\"keywords\":[\"Brenda Penman\",\"count\",\"Count Function\",\"counta\",\"countblank\",\"countif\",\"countifs\",\"dcount\",\"dcounta\",\"devsq\",\"dsum\",\"easy excel tips\",\"Excel\",\"Excel 2013\",\"Excel 2016\",\"Excel 2019\",\"Excel Calculations\",\"Excel Formulas\",\"Excel Tips\",\"excel tips and tricks\",\"Excel Tutorial\",\"Excel Tutorials\",\"Formula Tips\",\"Formulas\",\"frequency\",\"Learn Excel\",\"Microsoft Excel\",\"Microsoft Excel 2013\",\"Microsoft Excel 2016\",\"Microsoft Excel 2019\",\"Microsoft Excel Formulas\",\"subtotal\",\"sum\",\"Sum Function\",\"sumif\",\"sumifs\",\"sumproduct\",\"sumsq\",\"sumx2my2\",\"sumx2py2\",\"sumxmy2\",\"tutorial\"],\"articleSection\":[\"Microsoft Excel\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/excel_functions_count_sum\\\/\",\"url\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/excel_functions_count_sum\\\/\",\"name\":\"Excel Functions: Count and Sum - Brenda Penman\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/excel_functions_count_sum\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/excel_functions_count_sum\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.brendapenman.com\\\/wp-content\\\/uploads\\\/2018\\\/02\\\/Excel-Function-Count-Sum-0.png\",\"datePublished\":\"2019-10-30T14:57:55+00:00\",\"dateModified\":\"2021-11-21T22:38:44+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/#\\\/schema\\\/person\\\/1ac7a1b963fb0e6f6f2e518cce9721ef\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/excel_functions_count_sum\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/excel_functions_count_sum\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/excel_functions_count_sum\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.brendapenman.com\\\/wp-content\\\/uploads\\\/2018\\\/02\\\/Excel-Function-Count-Sum-0.png\",\"contentUrl\":\"https:\\\/\\\/www.brendapenman.com\\\/wp-content\\\/uploads\\\/2018\\\/02\\\/Excel-Function-Count-Sum-0.png\",\"width\":1080,\"height\":716,\"caption\":\"Excel Functions Sum and Count\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/excel_functions_count_sum\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel Functions: Count and Sum\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/\",\"name\":\"Brenda Penman\",\"description\":\"Learn Microsoft Office - Excel, Word, PowerPoint, Outlook, OneNote\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/#\\\/schema\\\/person\\\/1ac7a1b963fb0e6f6f2e518cce9721ef\",\"name\":\"Brenda Penman\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/12d4d8be4a4ca51ed4f62b1be1801d1361d03486de3abeb43b442ff0596828e3?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/12d4d8be4a4ca51ed4f62b1be1801d1361d03486de3abeb43b442ff0596828e3?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/12d4d8be4a4ca51ed4f62b1be1801d1361d03486de3abeb43b442ff0596828e3?s=96&d=mm&r=g\",\"caption\":\"Brenda Penman\"},\"url\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/author\\\/mfvwwyzbgoqzie\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel Functions: Count and Sum - Brenda Penman","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.brendapenman.com\/blog\/excel_functions_count_sum\/","og_locale":"en_US","og_type":"article","og_title":"Excel Functions: Count and Sum - Brenda Penman","og_description":"Commonly used Excel Functions are Sum and Count. There are several different Sum and Count functions available. Choose the one that calculates the answer you want. Here is a list of Excel Functions for Sum and Count [...]","og_url":"https:\/\/www.brendapenman.com\/blog\/excel_functions_count_sum\/","og_site_name":"Brenda Penman","article_published_time":"2019-10-30T14:57:55+00:00","article_modified_time":"2021-11-21T22:38:44+00:00","og_image":[{"width":1080,"height":716,"url":"https:\/\/www.brendapenman.com\/wp-content\/uploads\/2018\/02\/Excel-Function-Count-Sum-0.png","type":"image\/png"}],"author":"Brenda Penman","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Brenda Penman","Est. reading time":"15 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.brendapenman.com\/blog\/excel_functions_count_sum\/#article","isPartOf":{"@id":"https:\/\/www.brendapenman.com\/blog\/excel_functions_count_sum\/"},"author":{"name":"Brenda Penman","@id":"https:\/\/www.brendapenman.com\/blog\/#\/schema\/person\/1ac7a1b963fb0e6f6f2e518cce9721ef"},"headline":"Excel Functions: Count and Sum","datePublished":"2019-10-30T14:57:55+00:00","dateModified":"2021-11-21T22:38:44+00:00","mainEntityOfPage":{"@id":"https:\/\/www.brendapenman.com\/blog\/excel_functions_count_sum\/"},"wordCount":3083,"image":{"@id":"https:\/\/www.brendapenman.com\/blog\/excel_functions_count_sum\/#primaryimage"},"thumbnailUrl":"https:\/\/www.brendapenman.com\/wp-content\/uploads\/2018\/02\/Excel-Function-Count-Sum-0.png","keywords":["Brenda Penman","count","Count Function","counta","countblank","countif","countifs","dcount","dcounta","devsq","dsum","easy excel tips","Excel","Excel 2013","Excel 2016","Excel 2019","Excel Calculations","Excel Formulas","Excel Tips","excel tips and tricks","Excel Tutorial","Excel Tutorials","Formula Tips","Formulas","frequency","Learn Excel","Microsoft Excel","Microsoft Excel 2013","Microsoft Excel 2016","Microsoft Excel 2019","Microsoft Excel Formulas","subtotal","sum","Sum Function","sumif","sumifs","sumproduct","sumsq","sumx2my2","sumx2py2","sumxmy2","tutorial"],"articleSection":["Microsoft Excel"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.brendapenman.com\/blog\/excel_functions_count_sum\/","url":"https:\/\/www.brendapenman.com\/blog\/excel_functions_count_sum\/","name":"Excel Functions: Count and Sum - Brenda Penman","isPartOf":{"@id":"https:\/\/www.brendapenman.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.brendapenman.com\/blog\/excel_functions_count_sum\/#primaryimage"},"image":{"@id":"https:\/\/www.brendapenman.com\/blog\/excel_functions_count_sum\/#primaryimage"},"thumbnailUrl":"https:\/\/www.brendapenman.com\/wp-content\/uploads\/2018\/02\/Excel-Function-Count-Sum-0.png","datePublished":"2019-10-30T14:57:55+00:00","dateModified":"2021-11-21T22:38:44+00:00","author":{"@id":"https:\/\/www.brendapenman.com\/blog\/#\/schema\/person\/1ac7a1b963fb0e6f6f2e518cce9721ef"},"breadcrumb":{"@id":"https:\/\/www.brendapenman.com\/blog\/excel_functions_count_sum\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.brendapenman.com\/blog\/excel_functions_count_sum\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.brendapenman.com\/blog\/excel_functions_count_sum\/#primaryimage","url":"https:\/\/www.brendapenman.com\/wp-content\/uploads\/2018\/02\/Excel-Function-Count-Sum-0.png","contentUrl":"https:\/\/www.brendapenman.com\/wp-content\/uploads\/2018\/02\/Excel-Function-Count-Sum-0.png","width":1080,"height":716,"caption":"Excel Functions Sum and Count"},{"@type":"BreadcrumbList","@id":"https:\/\/www.brendapenman.com\/blog\/excel_functions_count_sum\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.brendapenman.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Excel Functions: Count and Sum"}]},{"@type":"WebSite","@id":"https:\/\/www.brendapenman.com\/blog\/#website","url":"https:\/\/www.brendapenman.com\/blog\/","name":"Brenda Penman","description":"Learn Microsoft Office - Excel, Word, PowerPoint, Outlook, OneNote","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.brendapenman.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.brendapenman.com\/blog\/#\/schema\/person\/1ac7a1b963fb0e6f6f2e518cce9721ef","name":"Brenda Penman","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/12d4d8be4a4ca51ed4f62b1be1801d1361d03486de3abeb43b442ff0596828e3?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/12d4d8be4a4ca51ed4f62b1be1801d1361d03486de3abeb43b442ff0596828e3?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/12d4d8be4a4ca51ed4f62b1be1801d1361d03486de3abeb43b442ff0596828e3?s=96&d=mm&r=g","caption":"Brenda Penman"},"url":"https:\/\/www.brendapenman.com\/blog\/author\/mfvwwyzbgoqzie\/"}]}},"_links":{"self":[{"href":"https:\/\/www.brendapenman.com\/blog\/wp-json\/wp\/v2\/posts\/3288","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.brendapenman.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.brendapenman.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.brendapenman.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.brendapenman.com\/blog\/wp-json\/wp\/v2\/comments?post=3288"}],"version-history":[{"count":5,"href":"https:\/\/www.brendapenman.com\/blog\/wp-json\/wp\/v2\/posts\/3288\/revisions"}],"predecessor-version":[{"id":3503,"href":"https:\/\/www.brendapenman.com\/blog\/wp-json\/wp\/v2\/posts\/3288\/revisions\/3503"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.brendapenman.com\/blog\/wp-json\/wp\/v2\/media\/3334"}],"wp:attachment":[{"href":"https:\/\/www.brendapenman.com\/blog\/wp-json\/wp\/v2\/media?parent=3288"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.brendapenman.com\/blog\/wp-json\/wp\/v2\/categories?post=3288"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.brendapenman.com\/blog\/wp-json\/wp\/v2\/tags?post=3288"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}