Hi All,
I'm looking to add cells with values greater than 0 that are not in a range. I want to add the total hrs from G5, M5, S5 and so on but with values greater than zero only. I don't know if this is possible but I would really appreciate the help. Thanks
EX.png
Last edited by MiglA06; 02-09-2021 at 03:19 AM.
Your title says COUNT but your request says ADD - which 1 is it?
either way, take a look at the sumif() function (or countif)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Sorry about that. I've tried both those functions but since it is not a range I get a too many arguments error. I only want to count those specific cells.
=SUMIF(G5,M5,S5,Y5,AE5,AK5,AQ5,">0")
SUMIF only takes 3 arguments...Criteria range, Criteria, sum range. Try this instead...
Sat Sun Mon Tue Wed Start End Ttl Hrs Start End Ttl Hrs Start End Ttl Hrs Start End Ttl Hrs Start End Ttl Hrs
P3=SUMIFS(A3:O3,A3:O3,">0",$A$2:$O$2,"Ttl Hrs")
That worked great. Thanks FDibbins
Great, happy to help and thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks