Hi All
I want to do a sumif on the following range but struggling:
C5,E5,G5,I5,K5,M5,O5,Q5,S5,U5,V5
The bit thats stumping me is i need to sum any empty/null cells in that range as a 10?
Can this be done using a sunif?
Kind Regards
Peter
I want to do a sumif on the following range but struggling:
C5,E5,G5,I5,K5,M5,O5,Q5,S5,U5,V5
The bit thats stumping me is i need to sum any empty/null cells in that range as a 10?
Can this be done using a sunif?
Kind Regards
Peter