Calculated field criteria

[MichaelMCSE]

Need a calculated field formula that looks at a field as criteria to sum, for example:
=IF(COLUMN1="MASTER") THEN COLUMN4(SUM)
instead of just =COLUMN4

Best regards,
Michael

 

[Joe Galvan]

You would have to name your ranges first...

Name Range:
Highlight desired column range and name in the Name Box in the left hand cornerish


but you should be able to use;

=SUMPRODUCT((Column1="Master")*Column4)