sum of parts by date

[dknipe77]

I have following:

Column A is dates
Column B is category list
Column C is amount paid

I am trying to do cashflow where want formula:

total sum of category 'cheese' paid in 'june'

[alansidman]

You will want to use the =SumIfs function. Here is a link on how to do it.

https://www.techonthenet.com/excel/formulas/sumifs.php

[dknipe77]

So I am still struggling with this. I have formula nearly sorted I think:

=SUMIFS(F2:F125,D2:D125,B9,MONTH(B2:B125),5)

where F2:F125 is range of figures want to total up,
where D2:D125 is range of products to equal B9,
and
where the date in column B9:B25 is month of May

[alansidman]

It may be helpful if you uploaded a sample worksheet that is representative of your actual file.

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.