Referring to 1 row in a named range

[comonand]

Hi all, pulling my hair out here, dont know what to google to find examples.

I have a table tblIsageData with a named range NameDay =TblUsageData[[#All],[08:30]:[17:00]],TblUsageData[[#All],[19:30]:[23:00]] Thats fine and works perfectly for other things,

I then have a column at the end of each row that sums the NameDay columns for just that row =SUBTOTAL(9,TblUsageData[@[08:30]:[17:00]],TblUsageData[@[19:30]:[23:00]]) That works fone too but I want to use NameDay instead.

How do i refer to just the active row in the table using NameDay something like =subtotal(9,ThisRow.NameDay) (i know that wont work, but cant for the life of me find an example)

TY

 

[Fluff]

How about

=SUBTOTAL(9,TblUsageData[@[08:30]:[23:00]] NameDay)

 

[comonand]

How about

=SUBTOTAL(9,TblUsageData[@[08:30]:[23:00]] NameDay)

Thanks for the reply

Im trying to sum just certain columns in each row (the ones in NameDay) using the NameDay name. I have a formula that does it using the actual column titles.

 

[Fluff]

Im trying to sum just certain columns in each row

That's exactly what that formula does.

 

[comonand]

That's exactly what that formula does.

Sorry, so it does thanks

 

[Fluff]

You're welcome & thanks for the feedback.