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.

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

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.

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

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

HTH
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=481707