I need an exception formula

[sllafleur]

This is what I am trying to do. I have 4 core sheets that I input information into and it automatically calculates in the "monthly" and "quarterly" sheets. Right now, I place a tally mark in everyday the volunteer firefighter went to a call. Somedays they have one and some days they have five. I need to incorporate the letter "L" for a particular call because they get paid less for that call than all the others.

This is the formula I am using right now
=SUM(I4*10) This formula is on the 4th quarter percentages tab which is the final tab for the 4th quarter and it calculates everything from the OCT-DEC in each month folder together.

I4 line is adding all fires, meeting, and events together and multiplying by $10. The other call I was referring to only receives $5.00. So I am needing to know how I can incorporate that into my current spreadsheet.

Thank you and I hope I didn't confuse y'all

Here is a visual of what the worksheet looks like.

 

[Dave87]

can you provide the data in xl2bb if not, can you provide another screenshot showing the row and column labels so people know where I4 is.
Its always a good idea to show what answers you expect to get so maybe fill in the first few rows manually before sharing

 

[beginvbaanalyst]

It sounds like you need an IF statement.
There isn't enough information to see in order to write it though.
Can you provide some data in the cells that usually have it?

 

[sllafleur]

can you provide the data in xl2bb if not, can you provide another screenshot showing the row and column labels so people know where I4 is.
Its always a good idea to show what answers you expect to get so maybe fill in the first few rows manually before sharing

This sheet just calculates everything

from these sheets

and these sheets record



everything from these sheets

So I need to be able to put an "L" inside these cells instead of a tally mark and excel immediately calculate the change or have excel recognize when I have two tally marks and an "L" like this

I really hope this makes sense now

 

[beginvbaanalyst]

Just to confirm your SEPT screenshot is what your database is set up like for OCT, NOV, and DEC?
Then your Rows going down from the screenshot for SEPT go like # fires made - inside, # fires made - outside, # meetings made, events?
Or do the rows represent each individual? (I assume it's this answer).
The tally marks"|" represent a $10 payout and the L represents a $5?
Just so I have this right, First row had a payout of $90?

 

[sllafleur]

Just to confirm your SEPT screenshot is what your database is set up like for OCT, NOV, and DEC?
Then your Rows going down from the screenshot for SEPT go like # fires made - inside, # fires made - outside, # meetings made, events?
Or do the rows represent each individual? (I assume it's this answer).
The tally marks"|" represent a $10 payout and the L represents a $5?
Just so I have this right, First row had a payout of $90?

The screenshot is how you perceived it. The rows represent each individual. Yes, on the last two