1Answers

# How does Excel seek and count the corresponding columns according to the specified information

Asked by: Lillian Shaw 28 views IT

As shown in the figure below: This is the three employees in the first half of the year. It can be seen that Li 1 participated in sales for 4 months in the first half of the year, with a sales amount of 1.98 million yuan.It is hoped that when the B2 unit is changed to Lee 2, it will automatically calculate that Lee 2 participates in the sales month and amount. How can the B2 and B3 cell enter the function?

+8

VotesB3

= Count (OFFSET (D2,1, MATCH (B2, E2: G2), 6))

B4

= SUM (OKSet (D2,1, MATCH (B2, E2: G2), 6))

James Taylor- August 11, 2022 |