=SUMPRODUCT(--(G3:G1176="story07"),--(H3:H1176<5000))
will COUNT how many have story7 in G and less than 5000 in H
=SUMPRODUCT(--(G3:G1176="story07"),--(H3:H1176<5000),H3:H1176)
will SUM the H's for rows with story7 in G and less than 5000 in H

for more see
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

http://mcgimpsey.com/excel/formulae/doubleneg.html

best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Natty" wrote in message
...
I current have a function like this;

=COUNTIF(G3:G1176,"story07")

This is okay it counts the number of story07's 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 don't know how to have the two functions in one. Can anyone
possibly
advise??