# Sumif Rows and Column with Data Validation Drop Down

#### rajkenya1

##### Member
In the attached spreadsheet i want a formula total amount amount in cell d10 which reflects the month in cell d7. So far example if D7 is April 20 then the formula should look at rows d14 to l14 (months) and sum everything in that column. For now i have manually inserted the amount.

#### Attachments

• 172.6 KB Views: 9

#### pecoflyer

##### Active Member
In your example there are multiple columns with the same header.
Whats is the difference between them?

#### pecoflyer

##### Active Member
Omitting cols D to J try =SUM(INDEX(\$K\$16:\$AA\$43,,MATCH(\$D\$7,\$K\$14:\$AA\$14,0)))

#### rajkenya1

##### Member
You are a genius. This works perfectly. Well done and thank you so much for taking the time out here to help. Thank you.

You're welcome

#### Somendra Misra

##### Excel Ninja
Hi,

Just another formula.

=SUMPRODUCT(--(\$D\$7=\$D\$14:\$T\$14)*\$D\$16:\$T\$43)

Regards,

#### rajkenya1

##### Member
Thank you so much Somendra. Bless