Frequncy Help, Please

  • Thread starter Thread starter ISAF Media Analysis
  • Start date Start date
I

ISAF Media Analysis

Looking for a formula that would measure across ranges. For example if I
wanted to caluculate how many time "US, BIG and Country" appeared together on
the same row, how would I do that.

A B C D
E
1 US BIG Country Country Town

2 CAN BIG Country City Village

3 AUS BIG City Country
Province

4 US BIG State Country Country

5 UK SMALL Province City Street

6 UK SMALL Country State Country

7 US SMALL City Country Town
 
Something like this, indicatively:
=SUMPRODUCT((A2:A10="US")*(B2:B10="BIG")*(C2:C10="Country"))

Mark all responses which help answer your query by clicking the YES button
below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
 
Better make a complete structure of a formula.

Tomorrow if any other text type condition arises with asterik works for AND
operation sort and unary signs helping out the same.

While as well to differentiate from the "+" sign, if required, for an "OR"
condition.
 
?
--
David Biddulph

FARAZ QURESHI said:
Better make a complete structure of a formula.

Tomorrow if any other text type condition arises with asterik works for
AND
operation sort and unary signs helping out the same.

While as well to differentiate from the "+" sign, if required, for an "OR"
condition.
Click to expand...
 
All right I just got your & Max's valuable point. U mean 2 say if * is used,
we don't need --? Thanx again. I thought it was necessary to have both.
 
Back
Top