Hi,
Is there anyway to shorten the below formula and therefore be able to inlcude more??
The 'C' cells will either have YES or NO; if NO i want the corresponding value in the 'G' cells to be added to a total but if YES i don't want it added. There is a limit of how many of these you can have in the formula and i have many more cells to include.
Any help would be much appreciated!!
Saint
=IF(C2="NO",+G2,0)+IF(C3="NO",+G3,0)+IF(C4="NO",+G4,0)+IF(C5="NO",+G5,0)+IF(C6="NO",+G6,0)+IF(C7="NO",+G7,0)+IF(C8="NO",+G8,0)+IF(C9="NO",+G9,0)+IF(C10="NO",+G10,0)+IF(C11="NO",+G11,0)+IF(C12="NO",+G12,0)
Bookmarks