Ask Your Question
0

struggling with a formula

asked 2016-07-30 17:04:27 +0100

JerseyErnie gravatar image

I have a spreadsheet in Calc for tracking our medical expenses. Col. D is text with my or my wife's initials. column C is the amount. need help to create formula for each of our totals by sorting on initials in D

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2016-07-30 18:36:56 +0100

mark_t gravatar image

updated 2016-07-30 18:38:49 +0100

=SUMIF(D2:D13,"MT",C2:C13)

Change "MT" to the initials for sum.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2016-07-30 17:04:27 +0100

Seen: 22 times

Last updated: Jul 30 '16