COUNTIF

gymwrecker · May 16th, 2002, 10:34 AM

I'm trying to create a formula using two conditions. The final result should be based on two conditions from two different columns. Format of both columns is text

For Example:
Column A Column B
Marksman M16A2
Marksman M16A2
Sharpshooter M249
Expert M16A2
Marksman M249

How could I have a result that only shows ALL the Marksman for M16A2, adding them using two different conditions? I'm using countif ....

Thanks!

Jay Petrulis · May 16th, 2002, 10:37 AM

Hi,

Try using SUMPRODUCT for multiple conditions.

=SUMPRODUCT((A1:A5="marksman")*(B1:B5="m16a2"))

HTH,
Jay

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 16th, 2002, 10:34 AM	#1
gymwrecker Board Regular Join Date: Apr 2002 Location: Fort Knox, KY Posts: 249	I'm trying to create a formula using two conditions. The final result should be based on two conditions from two different columns. Format of both columns is text For Example: Column A Column B Marksman M16A2 Marksman M16A2 Sharpshooter M249 Expert M16A2 Marksman M249 How could I have a result that only shows ALL the Marksman for M16A2, adding them using two different conditions? I'm using countif .... Thanks!

May 16th, 2002, 10:37 AM	#2
Jay Petrulis MrExcel MVP Join Date: Mar 2002 Location: Chicago, IL USA Posts: 2,042	Hi, Try using SUMPRODUCT for multiple conditions. =SUMPRODUCT((A1:A5="marksman")*(B1:B5="m16a2")) HTH, Jay