Totals Can Change Each Month

[rgillson3]

I have a spreadsheet I use to track ACH payments I submit, mainly on the 1st, 3rd and 5th.

I have months listed across in cells H3-S3.

In cell A3 I have the date for the month I'm working with.

Below, I have names in cells A5-A25, amounts in F5-F25. Then, under each month I have "boxes" where I insert an "X", or a non-normal date like "6th".

I want to show the current month's totals underneath each "section" in Column A.

Currently, I'm using the formula =IF($A$3=L$3,SUMIF($L$8:$L$10,"<>",$F$8:$F$10),0), which has to be edited each month.

I'm trying to find a new(er) formula that will allow me to only change the date in A3, then return the totals if I have the "X", or "6th" in the appropriate cells.

Is there a way to do this?

 

[Tetra201]

Try this:

=SUMIF(INDEX($H$8:$S$10,0,MATCH($A$3,$H$3:$S$3,0)),"<>",$F$8:$F$10)

 

[rgillson3]

Try this:

=SUMIF(INDEX($H$8:$S$10,0,MATCH($A$3,$H$3:$S$3,0)),"<>",$F$8:$F$10)

That did the trick.

Thank you.

 

[Tetra201]

You are welcome.