Skip to main content
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
  5.1K 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
2 years 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.