Forum Discussion
mark daskilewicz
Aug 27, 2017Copper Contributor
Conditional summation
I have a spreadsheet listing purchases for an ongoing home renovation. the columns list the date, store (e.g., home depot, lowes, Amazon), item name, cost, purchaser (myself or my wife). How can I ...
SergeiBaklan
Aug 27, 2017Diamond Contributor
Hi Mark,
Most straightforward way is to use SUMIF https://support.office.com/en-gb/article/SUMIF-function-169b8c99-c05c-4483-a712-1697a653039b or SUMIFS https://support.office.com/en-gb/article/SUMIFS-function-c9e748f5-7ea7-455d-9406-611cebce642b