Thread: What is the formula? If A:A is "1" AND B:B is "MACH: SUM F:F

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.

Hi,
Use an IF and AND formula:
=IF(AND(A1=1,B1="mach"),your sum formula,"")

HTH
JG

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.