Can I combine Sumif and If function?
I have a data spreadsheet with the following columns: DATE column, $$
column, STATE column.
Is there a formula that I can use so that when I update the data spreadsheet
it will automatically calculate for me as what I need below:

- If DATE column is filled in
- then do a SUMIF to calculate $$ for each STATE

I do have some rows without the DATE but $$ will be there, so I just want to
know if there's any formula that I can use