Recent content by marioletto

Skip, It's good to know that the pivot tables exhist, and for that i thank you. but i spend about one hour playing/learning pivot tables and they simply are not the tool for this task of mine. It's like you trying to convince me that taking a shower is a great way to to wash my hands. In...

> What do you have in A1? Should NOT BE TEXT! > For that matter NO TEXT in A1:A22 =sumproduct(($B$1:$B$22="Transportation")*($A$1:$A$22)) that's it, a little space was to problem! now it works like a charm. thanks. m.

pivot table tool: neat feature! a little too complicated for my needs.

=sumproduct(($B$1:$B$22="Transportation")*($A$1:$A$22)) Something like this would be nice!unfortunatlely this one gives me the #VALUE! error

pivot table tool: i can't get it to work with only 2 variables. if it was an sql query, it would be something like: sum A1:A22 where B=transportation thanks

hi all, i'm strugling with someting that should be quite simple. in my Excel sheet i have two colums: expenses and categories. (categories are in a drop down and pulled from an other sheet) i'm looking to find a way to calculate expenses by category possibly in a way that would update itself...