• 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.

Sumifs formula #Value!

S

sachar

Member
Dear All,

With reference to the attached sample file, I applied SUMIFS formula, but I am getting the wrong answer “#Value!

May I know what is wrong with SUMIFS formula?
 

Attachments

  • sample file_sumifs.xlsm
    34.6 KB · Views: 12
The ranges in the SUMIFS need to be the same size as each other and only one column in width.
 
Changed your Sumifs formula to :

=SUMIFS(INDEX(Sheet2!B$3:J$31,0,MATCH(Sheet4!F$10,Sheet2!B$1:J$1,0)),Sheet2!A$3:A$31,A2)

then, copied down

Regards
Bosco
 
Last edited:
Dear Bosco & AliGW,

Received with thanks, Ms AliGW can you please elaborate the following sentence with the formula.

"The ranges in the SUMIFS need to be the same size as each other and only one column in width."
 
You must log in or register to reply here.
Back
Top