Thread
:
Help
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
Fnipp
external usenet poster
Posts: 4
Help
This function adds everything in the column L2:L20. I only want to add if
the both conditions are met and if not then do not add the amount.
=SUM(IF(Time!B2:B20="F-10 CWE",IF(Time!C2:C20="L-02 SICK",Time!L2:L20)))
thanks,
Reply With Quote
Fnipp
View Public Profile
Find all posts by Fnipp