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,

Hi, try this

=somarproduto(--(Time!b2:b2="F-10 CWE")*(Time!C2:C20="L-02
SICK")*(TIME!L2:L20))

hth
regards from Brazil
Marcelo


"Fnipp" escreveu:

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,

Try this:

=SUMPRODUCT(--(Time!B2:B20="F-10 CWE"),--(Time!C2:C20="L-02
SICK"),(Time!L2:L20))

HTH,
Elkar

"Fnipp" wrote:

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,

thanks for the reply but I get this with the formula you suggested.

#NAME?


"Marcelo" wrote:

Hi, try this

=somarproduto(--(Time!b2:b2="F-10 CWE")*(Time!C2:C20="L-02
SICK")*(TIME!L2:L20))

hth
regards from Brazil
Marcelo


"Fnipp" escreveu:

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,

sorry i type in Portuguese is sumproduct

reagards

"Marcelo" escreveu:

Hi, try this

=somarproduto(--(Time!b2:b2="F-10 CWE")*(Time!C2:C20="L-02
SICK")*(TIME!L2:L20))

hth
regards from Brazil
Marcelo


"Fnipp" escreveu:

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,

it still adds everything in column L2:l20

"Elkar" wrote:

Try this:

=SUMPRODUCT(--(Time!B2:B20="F-10 CWE"),--(Time!C2:C20="L-02
SICK"),(Time!L2:L20))

HTH,
Elkar

"Fnipp" wrote:

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,

It seems to work just fine for me. What format is your data in L2:L20? Is
it Number, Time, Text?

Perhaps if you provided some examples of the data you're working with, the
results you want, and the results that you're getting.


"Fnipp" wrote:

it still adds everything in column L2:l20

"Elkar" wrote:

Try this:

=SUMPRODUCT(--(Time!B2:B20="F-10 CWE"),--(Time!C2:C20="L-02
SICK"),(Time!L2:L20))

HTH,
Elkar

"Fnipp" wrote:

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,

My format is Number

If I leave Column B and C Blank it will add the blank ones in column L.
Also I need a forumla to add the same way if the cell contains any of the
following from the drop down.

"Elkar" wrote:

It seems to work just fine for me. What format is your data in L2:L20? Is
it Number, Time, Text?

Perhaps if you provided some examples of the data you're working with, the
results you want, and the results that you're getting.


"Fnipp" wrote:

it still adds everything in column L2:l20

"Elkar" wrote:

Try this:

=SUMPRODUCT(--(Time!B2:B20="F-10 CWE"),--(Time!C2:C20="L-02
SICK"),(Time!L2:L20))

HTH,
Elkar

"Fnipp" wrote:

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,