Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF formula? | Excel Worksheet Functions | |||
writing a formula for a colored value | New Users to Excel | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Simplify formula | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |