Hi all...

Hoping you can help...

I'm fairly new to Excel but have been picking up bits and pieces (mainly from
this forum!!!)....

I've got a worksheet which has 20 columns and usually around 500 rows of data.
I am trying to use it to total the number of referrals received from specific
sources and for specific reasons...as there are over 15 sources and 5 reasons,
I have had to try to come up with a formula which will 'pick and choose' the
correct elements. To do this I am using the following forumla:

=SUMPRODUCT(--($W$2:$W$1000="Criteria 1"),--(!$V$2:$V$1000="Criteria 2"),--(
$O$2:$O$1000<"Branches"))

This works very well, and returns the actual volume of hits. However, I am
also trying to incorporate values. For each row, there will be a monetary
value (in coumn N). What I would like to do, is modify the formula I am
using so that it will total the values of the rows which meet my criteria.

Hope this makes sense?

Any help would be gratefully received

Matt