HELP! I want to add up the total # of units and sales per month. I have the units but I can't get the dollar amounts to add up. What am I doing wrong?
Units formula: =COUNTIFS($D:$D, "Yes", $C:$C, ">="&A2, $C:$C, "<"&A3 )
Volume formula: ??
| Month | Sale Price | Closing Date | Closed | Units | Volume |
| 01/01/2018 | $285,000.00 | 01-05-18 | Yes | 2 | |
| 02/01/2018 | $27,000.00 | 02-12-18 | Yes | 2 | |
| 03/01/2018 | $228,000.00 | 03-16-18 | Yes | 1 | |
| 04/01/2018 | $298,000.00 | 02-04-18 | Yes | 1 | |
| 05/01/2018 | $192,000.00 | 06-16-18 | Yes | 0 | |
| 06/01/2018 | $138,840.00 | 04-18-18 | Yes | 2 | |
| 07/01/18 | $23,000.00 | 06-19-18 | Yes | 2 | |
| 08/01/2018 | $145,000.00 | 08-19-18 | Yes | 1 | |
| 09/01/2018 | $360,000.00 | 09-22-18 | Yes | 1 | |
| 10/01/2018 | $179,900.00 | 01-23-18 | Yes | 1 | |
| 11/01/2018 | $95,000.00 | 10-23-18 | Yes | 2 | |
| 12/01/2018 | $195,000.00 | 11-24-18 | Yes | 0 | |
| $182,000.00 | 12-24-18 | Yes | |||
| $182,000.00 | 07-24-18 | Yes | |||
| $226,825.00 | 7/31/2018 | Yes | |||
| $135,500.00 | 11-02-18 | Yes | |||
| $189,000.00 | 12-15-18 | Yes |
Please supply the workbook so we don't have to key in the data and recreate everything.
If I enter your COUNTIFS formula into the Units column I get 0 for every answer. Without seeing your workbook I don't see how you get something different.
I don't see how you are calculating the number of units. The other info you've provided doesn't seem to allow such a calculation.
How exactly do you want Volume calculated? Is Volume a $ value or a number measuring something else?
Phil
Sorry I wasn't clear. This is a small part of a much larger worksheet that tracks real estate closings. I want to calculate the number of units sold per month and how much $ made each month.
It looks like you just need SUMIFS:
=SUMIFS($B:$B,$D:$D, "Yes", $C:$C, ">="&A2, $C:$C, "<"&A3 )
