Excel countif where criteria is on separate columns

A B C 1 Fruit 0.34 Pear 2 Vegetable 0.62 Lettuce 3 Fruit 0.80 Apple 4 Fruit 0.86 Banana Given the table above, I need to know the cost of all items above by type (fruits vs vegetables). In the above example, I'm looking for a formula that gives me Fruits=2.0 and Vegetables=0.62 and can apply to any number of rows. Any help would be appreciated!

以上就是Excel countif where criteria is on separate columns的详细内容,更多请关注web前端其它相关文章!

赞(0) 打赏
未经允许不得转载:web前端首页 » excel

评论 抢沙发

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址

前端开发相关广告投放 更专业 更精准