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

T

Tammy

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.
 
B

B. R.Ramachandran

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
 
P

pinmaster

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

HTH
JG
 
Top