Note: The other languages of the website are Google-translated. Back to English
Support is Offline
Today is our off day. We are taking some rest and will come back stronger tomorrow
Official support hours
Monday To Friday
From 09:00 To 17:30
  Saturday, 20 November 2021
  1 Replies
  2.6K Visits
0
Votes
Undo
I have a multitab spreadsheeton sheet 3, i use the formula  =SUM(N1:N7)    in N8 of Sheet 3

i want to insert data fron cell I13 on Sheet2, into Sheet 3, Cell N6, but Cell I13, Sheet 2 also has a formula of   =(R13-Q13)+1

I do not have to use this calculation from Sheet 2 all of the time, sometimes, it remans blank, so how can i get the dta to sheet 3, even if the dtat is blank on sheet 2?

So far, if it remains blank in sheet 2, then sheet 3 shows   #VALUE     in Sheet 3, N6 and the Sum in sheet 3 which is located in N8 of Sheet 3 also shows   #VALUE    and will not calculate the SUM of N1 through N7
1 year ago
·
#2355
0
Votes
Undo
Hi jbschaffer,

    You can add the IF and ISERROR functions to your famula in N8 of Sheet 3: =SUM(IF(ISERROR(N1:N7),"",N1:N7)). Remember to enter the formula with Ctrl + Shift + Enter as it is an array formula. For more details, please read the article here: https://www.extendoffice.com/documents/excel/1341-excel-sum-cells-with-errors.html
  • Page :
  • 1
There are no replies made for this post yet.

Follow Us

Copyright © 2009 - www.extendoffice.com. | All rights reserved. Powered by ExtendOffice. | Sitemap
Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.
Protected by Sectigo SSL