Average of columns

[yaelcohen]

Hello expert,

Thanks for any help

Attached an excel file with my question:
What should be the formula that bring the results of 14%
The conditions are: Sum all the lines of columns D/ Sum all the lines of columns C that
has Y in column F and G

Thanks a lot!

 

[A J]

Hi yaelcohen,

Add this formula in C16-

=SUMIFS(C3:C14,F3:F14,"Y",G3:G14,"Y")

Add this formula in D16-
=SUMIFS(D3:D14,F3:F14,"Y",G3:G14,"Y")

Cheers
AJ

 

[yaelcohen]

Thanks a lot ! it was fast!!!!