I have a spreadsheet which has multiple columns. I have SUMIF'ed some of the columns but now I wish to sum depending upon criteria in two separate columns, e.g.
I have the following data
Letter Direction Amount
A In 1
A In 1
A Out 2
B Out 2
B In 1
B In 3
A Out 4
C In 2
C In 1
I have SUMIF'ed for A, B and C and also SUMIF'ed for In and Out but now I want to SUM the Amount for Letter and Direction, i.e. I want the SUM of Amount for A and In, A and Out, B and In, B and Out, etc.
How do i say basically say If Letter=A and Direction =In then sum the Amount?
Thanks
John
Bookmarks