sum #n/a

  1. E

    how do i sum 2 vlookup totals & make a #N/A zero 0

    Hi, I am new to excel and I am looking to sum up two VLOOKUP totals firstly and in addition if there is no data that pulls a #N/A value how do I make that zero so it does not effect my other calculation relating to this total
  2. S

    Find dates in a range where a SKU from a list was out of Stock

    I have a master list of SKUs in one table set as a column with a different SKU listed in each row. I have another table with a daily snapshot of items which I have in stock between 7/1/17 and 7/31/17 in each row. The table shows the item SKU in one column, the warehouse where there is...
    • shantiopp
    • Thread
    • array count missing dates dates in formula missing data sum #n/a
    • Replies: 0
    • Forum: Excel Questions
  3. F

    Excel

    I am trying to calculate score that has 5 sections( minimum of 3 questions per sections). Among these some can be N/A. I need to calculate in such a way that the first 4 parts should be (Total Yes answers) / (total Yes+NO questions) * 10 and the 5th part should be multiplied by 60. Finally I...
  4. H

    Sum while getting #N/A

    i want to sum a column. It also contains #N/A. Also, i want to count the number of occurrences of values in the column (values can be alphabets, numerical or alpha-numerical) but it should not count #N/A. How to accomplish it? thanks
  5. H

    Sum while getting #N/A

    i want to sum a column. It also contains #N/A. Also, i want to count the number of occurrences of values in the column (values can be alphabets, numerical or alpha-numerical) but it should not count #N/A. How to accomplish it? thanks
  6. J

    How to ignore #N/A in the summation of a column

    Hello everybody. I am having a problem with a complicated workbook I have inherited at work. Currently, a cell with the formula =SUMIF(D$3:D$149,1,H$3:H$149) is returning a #N/A value because there are several #N/A cells in column H. How would I amend the formula to ignore any #N/A cells...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top