Share via

value error in sumifs function

Anonymous
2019-03-21T06:27:16+00:00

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.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

13 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2019-03-25T10:57:10+00:00

    I used SheeetsMaterialCon as named range form all the data sheets names in the workbook as shown in figure 2 above in column A.

    Regards,

    Yasir Ali

    0 comments
  2. Anonymous
    2019-03-26T10:03:34+00:00

    https://1drv.ms/x/s!AjHPdaK1mBVqgVLZRLlT\_NLY3ZKZ

    Check This link.

    Regards,

    Yasir Ali

    0 comments
  3. Anonymous
    2019-03-28T09:13:55+00:00

    Hi Yasir

    I made some changes to your spreadsheet which you can download from here.

    I wasn't able to get the array formula working. I got it partially working but can't get it to the result you require. Have a look at the formulas and comments I added on the worksheet 'Avg Cost'.

    I did come up with an alternative solution - hopefully it meets your need. See sheet 'TotalCost'

    0 comments