Hello from Steved
If no Data the cell is returning a 0 value I need it in this case to be
blank please.
SUM(IF('From Charters'!$A$1:$A$900="Roskill",IF('From
Charters'!$B$1:$B$900="Period.1",'From Charters'!$D$1:$D$900,0),0))
Thankyou.
Hello from Steved
If no Data the cell is returning a 0 value I need it in this case to be
blank please.
SUM(IF('From Charters'!$A$1:$A$900="Roskill",IF('From
Charters'!$B$1:$B$900="Period.1",'From Charters'!$D$1:$D$900,0),0))
Thankyou.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks