Ask Your Question
1

SUMIF: apply function input range [closed]

asked 2013-12-02 10:40:07 +0200

Muffinman gravatar image

Hello,

I want to use the SUMIF function to get the sum of some amounts in a certain year. However, to get the years from a date one needs to apply the YEAR() function. Is there a way to apply a function on a range? Or, have a function that returns the modified range? Something like:

=SUMIF(FUNCTION(YEAR();E$8:E$9000); "=2012"; P$8:P$9000)

Thanks in advance, Maarten

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-11-15 07:23:52.660664

1 Answer

Sort by » oldest newest most voted
1

answered 2013-12-02 15:20:26 +0200

Regina gravatar image

You can use

=SUMIF(YEAR(E$8:E$9000);"=2012";P$8:P$9000)

But you have to enter it as array function. That is, you have to finish entering by Ctrl+Shift+Enter, or in the wizard check the checkbox "Array".

edit flag offensive delete link more

Comments

Ok, thanks that works almost perfect. Under OS-X it is Command+Shift+Return(or Enter).

Muffinman gravatar imageMuffinman ( 2013-12-04 11:33:10 +0200 )edit

Question Tools

1 follower

Stats

Asked: 2013-12-02 10:40:07 +0200

Seen: 311 times

Last updated: Dec 02 '13