Help Needed Changing an Excel Formula

I have a spreadsheet tracking when people send me expense reports. I have column for each day and if someone sends expenses I mark a 1 in that cell. I use the following formula to record what day each person sent in their first expense:

=IFERROR(INDEX($B$1:$T$1,MATCH(1,$B3:$T3,0)),0)

However if someone sends in 2, 3 or more expense reports in one day I need to mark the corresponding value in the cell. But the above formula only recognizes the value one. How do I change it so that it'll pick up any value thats been added to a particular cell?

Thanks karedog, that worked!

One more thing you guys might be able to help with. I want a column at the end to calculate the total number for reports submitted by each person. At the moment I have this formula: =COUNTA(B2:T2)
The problem with this is no matter what value I have in a particular cell it'll only count it as one. What I would like is, for example, if I had 3 cells with values in a particular row and the values were 1,4 and 1 I want the column at the end to record the total as being 6 rather than 3. Can this be done?

Is it just the =COUNTA that needs to be corrected? If so what could I use?

Originally Posted by karedog

Hi,

Change to this formula :

Please Login or Register  to view this content.

Regards

I've actually run into an issue with this formula. The column that records the day people sent in their first report no longer works. It now records the last day someone sent in a report rather than the first day. What can I do to correct this while also recording when more than one report is submitted per day?