I want to look at the data in column A. I want to then sum all the data in column D of those rows that meet a certain condition in Column A. Specifically, any column A that has a value of "MD" in it, I want to sum the column D of those rows. Right now I have only 5 rows of data, beginning in row 7 and ending in row 11. But there could be more or less rows in the future.
I tried this formula:
=SUM(IF(A7="MD",D7,0):IF(A11="MD",D11,0))
When I use a comma instead of a colon (to test only 2 conditions instead of a range of conditions), it works just fine. When I use the colon, however, it doesn't work properly.
Any help would be appreciated.