SUMPRODUCT formula query

[broncos347]

I currently have a spreadsheet tracking work on a series of sites and I am currently using the following formula to summarise the data in column CI:

=SUMPRODUCT(--('New Sites'!$AS$5:$AS$84="roura"),--('New Sites'!CI5:CI84<>""))

However, there are a number of sites that are on hold and what I would like to also do is omit those sites which are currently labelled as on hold on column FJ.

Does anyone know if the above formula can be amended to include what I want?

 

[NBVC]

Just add to your current function:


=SUMPRODUCT(--('New Sites'!$AS$5:$AS$84="roura"),--('New Sites'!CI5:CI84<>""),--('New Sites'!$FJ$5:$FJ$84<>"on hold"))