I am new to the boards and learning a lot here. But, I am confused by the
"--" in the below sumproduct formula. What does it mean?
--
Clark


"Barb Reinhardt" wrote:

Try
=sumproduct(--(G3:G1176="story07"),--(H3:H1176<5000),(H3:H1176))

"Natty" wrote:

I current have a function like this;

=COUNTIF(G3:G1176,€�story07€�)

This is okay it counts the number of story07s in that range

I also have a SUMIF;

=SUMIF(G3:G1176,€�story07€�,H3:H1176)

H is the fee, so this adds all the fees for story07 together.

What I would like to do is count the number of story07 in the range that
fall into income bands

So something like €¦

=COUNTIF(G3:G1176,€�story07€�) AND SUMIF(H3:H1176,<5000)

But I dont know how to have the two functions in one. Can anyone possibly
advise??