SUMIF criteria in row not columns

[coop123]

Hi

I am sorry if this question has already been resolved but I cannot find a solution that meets my needs.

I have spread sheet where the criteria is in row 5 and sum range is also a row.

The problem is the number of columns containing the criteria will be different each time report is run.

In above example there are only 2 sets of data, next time there maybe 4 sets or just 1.

I need to be able to sum the data if there are 2 records or 4 or 1.

I hope I have explained suffeciently.

Thanks for any assistance you can give.

Coop123

 

[Alex Blakenburg]

Sorry not sure what I did there.

For a single cell:-

    sht.Cells(firstRow, lastCol).FormulaR1C1 = _
        "= SUMIFS(RC3:RC" & lastCol - 1 & ",R" & hdgRow & "C3:R" & hdgRow & "C" & lastCol - 1 & ",""PO + Req'n"")"

If you meant a single column then:-

    sht.Range(Cells(firstRow, lastCol), Cells(lastRow, lastCol)).FormulaR1C1 = _
        "= SUMIFS(RC3:RC" & lastCol - 1 & ",R" & hdgRow & "C3:R" & hdgRow & "C" & lastCol - 1 & ",""PO + Req'n"")"

 

[coop123]

Hi Alex

Thats perfect. It now does exactly what I want.

Thank you for your support it has been very much appreciated.

coop123

 

[Alex Blakenburg]

No problem. Glad we could help and thanks for letting us know.