Function to use in Google Sheet. Sum with IF condition -
assume have 2 rows below
b c expendicture whom <total cost mr x> 500 mr x <total cost mr y> 300 mr y 463 mr y 764 mr x 63 mr y
whats functions find cost of x , y separately , paste in column c? assume columns , b infinite.
juse use sumif, same in excel can specify infinite range more easily:
=sumif($b$2:$b, "mr x", $a$2:$a)
https://docs.google.com/spreadsheets/d/1bxmf_wtht6bxztsmpqvp18yob9jcksnidbjq1j44ad0/edit?usp=sharing
Comments
Post a Comment