Countif ??

[Graham]

Hi ,

What is the function i need to use if I wish to sum of
column K (dollar value ) , if column A = "example 1" ,
Column C = "example 2" , Column D = "example 4"

Thanks in advance.

Graham

 

[Ragdyer]

Try this:

=SUMPRODUCT((A1:A100="example 1")*(C1:C100="example 2")*(D1100="example
4")*K1:K100)

 

[Domenic]

Hi,

=SUMPRODUCT((A1:A100="example 1")*(C1:C100="example
2")*(D1100="example 4"),K1:K100)

Hope this helps!

 

[Biff]

Hi Graham!

Try this:

=SUMPRODUCT(--(A1:A100="example 1"),--(C1:C100="example
2"),--(D1100="example 4"),K1:K100)

Biff