value error in sumifs function

Question

I created Sumifs function in which sum range is C5:F7 and criteria range 1 is B5:B7 and criteria 1 is J5 and criteria range 2 is C4:F4 and Criteria 2 is K4. The above is shown in figure below;

Any help would be highly appreciated.

Answer 1

Hi Murray,

Thanks for your reply. I used array formula as suggested by you but it did not work. I am sending you OneDrive data link for your review. Please check this.

https://onedrive.live.com/edit.aspx?cid=6a1598b5a275cf31&page=view&resid=6A1598B5A275CF31!210&parId=6A1598B5A275CF31!111&app=Excel

Regards,

Yasir Ali

Answer 2

That link gives me an error saying "This item might not exist or is no longer available" Yasir.

To share the link, select the file in OneDrive (don't open it), click on Share in the menu across the top, copy the link that it shows in the dialog box and then post that link here.

Answer 3

Hi Murray,

In the Share Dialogue box, email ID is required of the person to whom Data to be shared.

Plz share me your mail ID. 

Regards,

Yasir Ali

Answer 4

That's not possible - the website strips out email addresses for privacy.

As per picture below, when you click on Share it should give you two options, one including a link to copy and one to email.

Click ''Copy' to copy the link. You have to have selected the file first so that it appears with a blue tick in the corner (which you can also see in the picture).

Answer 5

What is in the named range SheetsMaterialCon? Can you show a picture of it?