Sum with multiple criteria

[mnunan]

Hi

Can anyone help with the following formula please, I need to:

Sum the cells in column G where the date in column D is between the dates specified in cells B2 and C2 (in a different worksheet) and where the text in column B is "LHR" and where the the cells in column L are not blank.

Column D = date
Column G = currency
Columns B & C in a different worksheet = date
Column L = text

Thanks very much

 

[mnunan]

Are you saying that ...$L$2:$L$400,"LHR"... should be ...$B$2:$B$400,"LHR"... ?

Maybe this:

=SUMIFS($G$2:$G$400,$D$2:$D$400,">="&Sheet2!B2,$D$2:$D$400,"<="&Sheet2!C2,$B$2:$B$400,"LHR",$L$2:$L$400,"?*")

This is perfect, thanks so much for your help

 

[T. Valko]

This is perfect, thanks so much for your help

You're welcome. Thanks for the feedback!

 

[Aladin Akyurek]

Hi

I have tried both the sumproduct and sumifs, sumproduct returns 0 and sumifs says too few arguments. Also, the last part of the formula you have suggested should be referencing column B not L and there doesn't seem to be an argument to check if column L is not empty?

Thanks again

Just for the record: Editing the copied SumProduct version to SumIfs left the = sign untouched. It's an edit error rather than anything else.