MrExcel Publishing
Your One Stop for Excel Tips & Solutions

IF Then COUNTIF


Posted by Paul Walton USAF on December 13, 2001 7:53 AM

Can this be done... Trying to count items in column M only if column A equals a set value


If Sheet1 Col A:A = "Test" then count sheet1 Col M:M if equaled to the value of sheet2 cell A2

=IF(SHEET1!A:A="TEST",COUNTIF(SHEET1!M:M,"TEST"),"")

Thanks for your Help


Posted by Aladin Akyurek on December 13, 2001 8:08 AM

Paul --

That is a bit ambigous.

Is it

=COUNTIF(Sheet1!M:M,Sheet2!A2)

If not, care to elaborate?

Aladin

=======

Posted by Paul Walton USAF on December 13, 2001 8:47 AM


I need Sheet1 Col M to count only if Sheet1 Range A2:A5000 equals a set value
example..
count only if A2:A5000 = "A0141" and M = "14ABC"

Posted by Aladin Akyurek on December 13, 2001 8:57 AM

Now we are in business:

Try:

=SUMPRODUCT((A2:A5000="A0141")*(M2:M5000="14ABC"))

Aladin

========== : Can this be done... Trying to count items in column M only if column A equals a set value Paul -- That is a bit ambigous. Is it =COUNTIF(Sheet1!M:M,Sheet2!A2) If not, care to elaborate? Aladin ======= :


Posted by Paul Walton USAF on December 14, 2001 7:20 AM

Works as advertised..

Thank you for your help.