Sumproduct help

[Paddy1979]

Hello all,

I need some help.

Im trying to the sum the total values in Column F , where the text is "W" in column D on the same row.

I have got this far , can somebody please help?

=SUMPRODUCT(--($D$1:$D$96="W"),--($F$1:$F$96))

Many Thanks

 

[Norie]

Couldn't you just use SUMIF?

=SUMIF(D1:D96,"W",F1:F96)

 

[Barry Katcher]

If you're only using criteria from one column (col. D in your example), you can use a SUMIF() formula:

=SUMIF(D1:D96,"W",F1:F96)

 

[Paddy1979]

Thanks Mate ,

I should have known that, what a dope