I have applied IF to 5 cells that work but one wont

[kaityc]

Hello everyone, my name is Kaity and I'm new to this forum.
Just after help please, I have applied this equation to 12 cells that all work as it should.

=IF('Cashflow Log January'!C4='Cashflow Log January'!J8,'Cashflow Log January'!G4)
Equation that works
I have applied the same equation to the final cells I need however it wont add them up as the other are.

=IF('Cashflow Log January'!C4='Cashflow Log January'!J9,'Cashflow Log January'!G4)
This is the equation that is not working.

can anyone see the error I have made and how I can fix it?

Thank you,
Kaity

[:) Sixthsense :)]

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[kaityc]

did that work?
There should be 2 files uploaded

[:) Sixthsense :)]

did that work?

I don't see any files in your posts

[FDibbins]

Hi, welcome to the forum

You say they wont add up, but there is nothing there that would sum anything. Your formula is simply testing 1 cell against another, and if they match, show the value from another cell

Without seeing more detail, maybe this is what you want?

=IF('Cashflow Log January'!$C$4='Cashflow Log January'!J9,'Cashflow Log January'!$G$4)

[kaityc]

Sorry I dont know why it isnt allowing me to upload a file.

Thanks, I tried that code however it still doesn't work.

Is there a way I can email them to you?

[FDibbins]

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

[kaityc]

thank you, I have now uploaded two very large photos sorry but there are now visible.
In the first photo is an example of terry and the sums that automatically add up on the right.
The other 2 I used the same equation but it isnt auto populating and I'm unsure as why.

Thank you

[FDibbins]

Sorry to be a pain, but we would prefer to have a sample WB, not a pic. We cannot really play around with pics

Also, please explain what you are trying to do here? You showed a formula that doesnt work, but that doesnt say what you are doing

[kaityc]

I am trying to create on spreadsheet Cash flow january - an automated add on for the drop down list. It is a cash flow distribution, so it will automatically add up person by person and then month by month so the overview page will be automatically updated.
Hope this explains it a bit better. The working out is on sheet 1.
Thank you

[FDibbins]

1st, you have a circular reference error in your sheet - that is when a formula in a cell, references the cell it resides in.
A quick check tells me that on sheet Overview, you have
K10=SUM(K4:K10)
As you can see, K10 is referencing itself in that formula. It should be
=SUM(K4:K9)
The same is happening in at least L10

2nd, you would be far better served if you have ALL data on 1 sheet, rather that a sheet per month. This will make all summaries much simpler.

3rd, please show some sample data, and expected outcome, so we know what you want

[kaityc]

Thank you for checking on this it is very helpful having help like this

I am trying to create a basic cashflow management / distribution log excel template.

It is just a logbook of petty cash expenditures with a drop down menu and then on the overview page I would like it to give the report based on the dropdown menu and the date.
How can I best do that?

Thank you again, this forum is extremely helpful.

[Roel Jongman]

The values in dropdown "Other 2" and cell J9 "Other 2 " dont match.
Can you spot the difference?

Well it is the most annoying problem to have.. (for the human eye to find)
In J9 the value has a space after the number 2 therefor there is no exact match for the text strings
remove the space after "Other 2 " in J9 and it will work fine..

[kaityc]

OH MY GOD i feel so silly! Thank you so much!!!!

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.