Hello,
Does anyone know a formulae that would allow you sum rows by the number of columns chosen.
E.g. Jan - Dec = 12 months/Columns.
I want to tell it to sum 7 month (For Jan-Jul)
Hello,
Does anyone know a formulae that would allow you sum rows by the number of columns chosen.
E.g. Jan - Dec = 12 months/Columns.
I want to tell it to sum 7 month (For Jan-Jul)
B7=sumproduct((month(b1:m1)<=right(b6,2)+0)*(a2:a3=a7)*(b2:m3))
another way is to utilize offset function:
=SUM(B2:OFFSET(B2,,VALUE(RIGHT($B$6,1))-1))
<----- If you are happy with your solution please click on the "* Add Reputation" as a way to say thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks