• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Adding the previous quantities

aamirsq

Member
Hi,

i am adding the previous quantities by using the below formula in excel its working fine but when i put it spreadsheet its not working

=SUM(B4:INDEX(B4:M4,MATCH($H$1,$B$3:$M$3,0)))

H1 : is my selection month

Row B3:M3 is my date
Row B4:M4 is my data which is i am adding using above formula.:awesome:

Thanks
 
Hi Aamir ,

In the absence of data , only you can troubleshoot the problem.

Does H1 contain a date , or is it formatted to show dates ? Place the cursor in the cell and convert its format to General or Number , and note down the value.

Now do the same for the range B3:M3 and see if there is any matching value.

If there is a match in the range B3:M3 for the date in H1 , then the formula should give an output ; whether this is the correct output or not , only you can say.

Narayan
 
Hi Aamir ,

Google Spreadsheets does not seem to accept this formula. Instead it accepts this :

=SUM(OFFSET(B4,,,1,MATCH(H1,B3:M3,0)))

Narayan
 
Back
Top