Paramedic needs formula help!

[David Erdman]

I'm measuring some of our prehospital procedures with MS Excel and I'm
having a hard time with complicated formulas.

I have two columns with data. I need to count all the criteria in one column
only if it matches another criteria in the second column.

Any help would be appreciated. I assure you all that I am a far better
paramedic than I am an Excel user.

Lieutenant Dave Erdman
Broward Sheriff's Office
Department of Fire Rescue

(e-mail address removed)

 

[Peo Sjoblom]

One possible way

=SUMPRODUCT((range1=criteria1)*(range2=criteria2))

or maybe

=SUMPRODUCT((range1=range2)+0)

 

[amby]

hi david
you can create an additional column that will match the
values and return true or false
then you can count this column using the countif(range,criteria) function
regards
ambrish
www.simplesoftconsultants.com

 

[jee22]

=SUMIF(A1:A31,"<=10",B1:B31)

A B
10 130
149 180
102 63
183 105
15 99
28 168
155 80
182 44
123 117
179 68
88 132
86 84
11 52
68 23
88 93
124 69
195 162

130

note that in col "A" there is only one number <= 10 and it's opposite is 130