Sum items from Data Validation list, help

[brandonfix]

I am trying to do what seems to be easy enough but I can not figure it out.

Excel 2007
Scenario: I have a fairly large budget spreadsheet and there are money categories in column E. The categories are in a drop down using simple data validation (Federal, State, Transfer, etc.). I have a money type summary section at the bottom of the spreadsheet and I would like to show Totals for Federal, State, Transfer etc. I can not get this formula correct and it seems like there are several ways to do it but I am missing something.

I have tried =IF(E4:E588="Federal", SUM(K3:K588)) but this is no good, doesnt work at all.

E = column with money type
K = column with total $ for each line item

I just need to have it pick up if the money type = federal then SUM every one from this column here and so on for each of the other money types, with a corresponding formula for State totals etc.

Please help, I have to have this done for a client in the morning and I have tried it so many ways.

 

[jeffreybrown]

Hi & Welcome to the Board,

Maybe you could try...

=Sumproduct(--(E3:E588="Federal"),K3:K588)

You noted E4:E588, but the columns must be the same size.

Note: I see you stated 2007 so you can use Sumifs >> =SUMIFS(K3:K588,E3:E588,"Federal")

 

[brandonfix]

My friend, problem solved, THANK YOU so very much.

=SUMIFS(K3:K588,E3:E588,"Federal") works great. Life saver.

Thanks again, have a great night.

Brandon

 

[jeffreybrown]

You're Welcome...Have a great night yourself