I cant get your question but i ll explain it little
if you have used this function in a cell
i.e
=if(CELL443,6,0)
which is equal to the 6 if CELL4 is greater than 43
Now you want to add this 6 of if function into to other cells of rows or columns then
Also Note that i have used this function =if(CELL443,6,0) in CELL5
simply do the following
=SUM(CELL5:36)
or
=SUM(CELL5:CELL2)
etc
If you not got that then explain your Question.
Quote:
Originally Posted by Vinay Vasu
Hello there,
I am using IF function to return values as digits. Now I need the sum of
such digits in a coloumn. Pease help me to do this.
Thank you
Jeevan
|