How to get the sum of a column based on two helper columns
I have a sheet with a column of numbers that I want to add based on a date range of two columns in a sheet summary.
This is what I have so far but it keeps coming back #UNPARSEABLE:
=SUMIFS([Helper RPF]:[Helper RPF], =2, [Mississippi County 50 Slots - IAR]:[Mississippi County 50 Slots - IAR]) OR([Helper RPT]:[Helper RPT], =2, [Mississippi County 50 Slots - IAR]:[Mississippi County 50 Slots - IAR])
Basically what I want to happen is a sum of the cells in the column named Mississippi County 50 Slots - IAR in the sheet summary based on the date range for each month in Rent Period-From and Rent Period- To. To make things easier I added helper columns to give the number value for each date
Help Article Resources
Check out the Formula Handbook template!