sumif formula required

[jenniferThomson]

Hello

I have only basic knowledge of excel and need a formula to extrac
information.

A B C
Client Process Sqm
CEK Fibre 100
RDF Gloss 200
ERF Emul 150
CEK Fibre 100

What formula should I use to extract all CEK clients who purchase th
fibre process giving total sqm.

I would be extremely grateful to anyone who can help me.

Regards

Jennife

 

[shades]

Use the SumProduct formula (it handles more than one condition). You
cannot use full column references (A:A), however, in SUMPRODUCT.

=SUMPRODUCT(($A$1:$A$300="CEK")*($B$1:$B$300="Fibre"),$C$1:$C300)

 

[jenniferThomson]

Hi

Thank you very much. This will save me lots of time.

Regards

Jennife

 

[Ken Wright]

You can either:-

Use Data Filter / Autofilter in conjunction with the SUBTOTAL function, which
will Sum only the visible rows after filtering,

or

You can use something like SUMPRODUCT eg:-

=SUMPRODUCT((RngA="CEK")*(RngB="Fibre")*(RngC))