Hi All, newbie forum member here but long term "jack of all" and hope I can answer as many questions as I ask :-)

I have a question regarding a spreadsheet task I am working on. (Mention now that Pivot tables are a little mystery to me and I have a feeling people are going to point me in this direction so please go slow).

I am trying to sum a number of non-sequential columns based on criteria from another column. I have managed to make it work on one row only, but when I try and expand this out to multiple rows (>800), I can't make it work. The formula I have that works on 1 row is below, and hope this explains in more detail.

=IF('Resource Projection'!D40='Plan V Actual'!J6,SUM('Resource Projection'!Q40,'Resource Projection'!S40,'Resource Projection'!U40,'Resource Projection'!W40,'Resource Projection'!Y40,'Resource Projection'!AA40,'Resource Projection'!AC40),0)

Cell J6 is the resource name reference. The above works fine for only one row, but I want to expand the range out to all 800 rows but conditionally sum only based on resource name.

Thanks in advance all for any help you can offer.

Paul