Referring to column letter/row numbers

Hello all,

I'm currently setting up an invoicing spreadsheet, and have a formula which uses an INDIRECT and LOOKUP function to sum costs for the month selected by the user.

Is there a way to perform the following function

Please Login or Register  to view this content.

=indirect(A1&*row number*) - to return 7 when in row 1 and 21 when in row 2

Currently I'm having to use the following setup:

Please Login or Register  to view this content.

This breaks somewhat when you have to insert a row and the numbering in columns C does not continue.

If anyone wishes to see an extract from my worksheet to see exactly what I'm using it for, please let me know.

Thanks,

Scriv

It would be more helpful if you uploaded a sample workbook and explained more clearly the logic of what to sum.

Possibly, you could use the SUMPRODUCT function.

Apologies, it's quite difficult to describe this in words.

Attached is the basics of what I need to do.

The only cells managers should need to edit are those in green and the hours of each staff member.

Choosing a month from cell D1 will automatically sum the hours for that month, based on the table starting in row 15.

The formulas I'm having trouble with are in column AO. This is because they rely on the numbers in column A, which are simply the numbers of the rows they are in.

In time I'd also like a system to improve the lookup table starting in A15, but I haven't figured this out yet.

Thanks again