Hi Lapo Zanuso
SUMPRODUCT will be the way to go, as SUMIF/SUMIFS cannot accept arrays. If you need to sum by year, the SUMIF and YEAR functions cannot be used together. Assuming your data is set up as your post:
Col A = Date
Col B = Expense
Col C = Category
Axample:
=SUMPRODUCT(--(YEAR(A1:A100)=2012),--(C1:C100="DIY"),B1:B100)
Quote:
Originally Posted by Lapo Zanuso
Hello
i need help with a function
i have 3 columns
A is a date like jan 2012, feb 2012, ... and so on
B is an expense 10,00$, 20,00$, .... and so on
C is a category like Fuel, House, DIY, Car Repair, ... and so on
i need a function that sums all the expenses on a certain category in a year
Thanks for your help!!!!!!!!!
|