Okay so here's what I have and I really hope someone can help me!
cells.jpg
I have three columns on this sheet that are of importance that contain these formulas:
S113 calculates the total of the entire S range above: =SUM(S2:S111)
S114 calculates the total of the S range AS LONG AS the G column has the word "booked in it: =SUMIF((G2:G111),"BOOKED",(S2:S111))
S115 calculates the total of the S range AS LONG AS the G column has the word "un-booked" in it: =SUMIF((G2:G111),"UN-BOOKED",(S2:S111))
The T column has the same formulas as above except the S is replaced with T in every formula.
The U column is just the comparison between S113 and T113 (=(S113-T113)/T113), S114 and T114 (=(S114-T114)/T114), and S115 and T115 (=(S115-T115)/T115) in a percent format.
What I need help with is this:
If a row has the word NULL in column S or T, I need all of the forumlas at the bottom of S and T to completely ignore the valumes in that ENTIRE ROW. So as you can see from the picture above, T108 has the word "NULL" in it. What I would want is for all of S113, S114, and S115 to completely ignore any values in S (S108 for this example) since T has "NULL" in it. We are trying to get as accurate of a comparison as possible for this data and since there is no data for T108, it will not provide for an accurate comparison.
Can anyone help me please?
Bookmarks