I have a spreadsheet with 3 columns - I want to know the number of times col
A = texta, and col b = textb and col c = text c. how do I do this in excel?
Number of times texta is found in column A: =COUNTIF(A:A,"texta")
Number of times column A, B and C in the same row have specified text
=SUMPRODUCT(--(A1:A100="texta"), --(B1:B100="textb"), --(C1:C100="textc")
Adjust the ranges as needed
Only in Excel 2007 can us you full column references
=SUMPRODUCT(--(A:A="texta"), --(B:B="textb"), --(C:C="textc")
Adjust the ranges as needed
Also only in XL 2007:
=COUNTIFS((A:A, "texta", B:B, "textb", C:C,"textc")