Welcome Guest.

1Answers

Seeking knowledge: screening multi-condition data summation in the same month of the same year

Asked by: Maria Moore 274 views IT August 10, 2018

Seeking knowledge: screening multi-condition data summation in the same month of the same year

1 Answers

  1. +5Votes  

    You can solve this problem in two ways. 1. Connect all the identifiers that participate in the summary into one identifier, sort, and sort the summary as you insert a column. The content is =CONCATENATE(LEFT(A1,9), A2, A4) Use this as a keyword subtotal 2. Use SUMif() or  SUMIFS() to refer to EXCEL connection help

     

    Marie- August 10, 2018 |