Hi,

Try the following formula, after changing the ranges to suit to your data:

=SUMPRODUCT((A2:A101=1)*(B2:B101="mach")*(F2:F101) )

Regards,
B. R. Ramachandran


"Tammy" wrote:

Can't figure this simple formula out. Column A contains #'s 1-6, B contains
text, and F contains mins. All I need to say is "if a is 1 and b is mach sum
f.