J
J Fraggis
I am working with Excel 2003 - SP3.
From what I understand, if you need to calculate a total number o
items that must meet 2 or more criteria, then COUNTIF is not possible.
I have tried the SUMPRODUCT formula as follows:
=SUMPRODUCT((A1:A100="word1")*(B1:B100="word2")) and amended t
appropriate columns but no matter how I tweak this, my total is alway
0. If I amend the * then I get all items matching Criteria 1 an
Criteria 2 but not exclusively.
What I need is a total number that includes only those items meetin
criteria 1 ("WEST" in Column 1) and criteria 2 (Postal Codes startin
with "N").
Is it a format problem with my columns - text vs. number etc?
Any assistance would be appreciated...it will save me creatin
worksheets and breaking the info out manually.
Thank you in advance..
From what I understand, if you need to calculate a total number o
items that must meet 2 or more criteria, then COUNTIF is not possible.
I have tried the SUMPRODUCT formula as follows:
=SUMPRODUCT((A1:A100="word1")*(B1:B100="word2")) and amended t
appropriate columns but no matter how I tweak this, my total is alway
0. If I amend the * then I get all items matching Criteria 1 an
Criteria 2 but not exclusively.
What I need is a total number that includes only those items meetin
criteria 1 ("WEST" in Column 1) and criteria 2 (Postal Codes startin
with "N").
Is it a format problem with my columns - text vs. number etc?
Any assistance would be appreciated...it will save me creatin
worksheets and breaking the info out manually.
Thank you in advance..