I am using the following formula to calculate time on a timesheet.
If I want it to show blank, if there is no time, how do I add that into this formula?
=SUMIF($D$8:$D$155,"=2232",$G$8:$G$155)
Thanks for your help!
I am using the following formula to calculate time on a timesheet.
If I want it to show blank, if there is no time, how do I add that into this formula?
=SUMIF($D$8:$D$155,"=2232",$G$8:$G$155)
Thanks for your help!
what is the =2232 for
you have to put it in an if statement
if(formula=0,"",formula) is the basic form
=if(SUMIF($D$8:$D$155,"=2232",$G$8:$G$155)=0,"",SUMIF($D$8:$D$155,"=2232",$G$8:$G$155))
but in light of the above post
=if(SUMIF($D$8:$D$155,2232,$G$8:$G$155)=0,"",SUMIF($D$8:$D$155,2232,$G$8:$G$155))
may be better
Regards
Dav
Sorry, I should have been more descriptive.
The 2232 is the account code that the time is being coded to.
One column, the employee puts the account code, and then the next column is their time in, then in the next, their time out.
The formula I am using is looking at the account code column, and adding up all the hours that went to that particular account code.
There may have been an easier way to do that, but I couldn't figure it out and am surprised I got it this far!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks