Job Recruitment Website - Recruitment portal - Add similar lines in excel.
Add similar lines in excel.
= sumprod ((a1:a100 = "secretary") *B 1:B 100)
= sumprod ((a1:a100 = "animal husbandry and veterinary") *B 1:B 100)
Two formulas correspond to your two requirements!
The numerical area of PS: can be modified. Suppose your value is in the 500 rows of column AB, then change it to:
= sum prodc((a 1:A500 = " secretary ")* b 1:B500)
= sum prodc((a 1:A500 = "animal husbandry and veterinary") *B 1:B500)
============================================
I didn't see the answer upstairs until I finished answering. He's right. Choose him!
- Related articles
- Where is the Longquan Luodai in Chengdu?
- What does the peak accounting season mean?
- How about Kunshan Third People's Hospital?
- Is there a life teacher in Chendian Experimental Primary School?
- Yangzhou primary school teacher recruitment
- Hunan Shenghua Recruitment
- Is it true that Yiwu Liwen ornaments?
- About applying for intermediate interpretation time in Wuhan
- Urumqi Branch of China Ping An Life Insurance Company of China Insurance Company recruited me as a business representative, saying that the basic salary was 2,500, and asked me to lead a small team of
- Which is better, Dawei Jia Pig Farm or Mu Yuan?