Forum Discussion
Solved
SUMIF
Am I going mad? - Is the formula wrong, or is it not reading Column E because it, itself is a formula calculating the difference between C & D!? Pulling my hair out!
Riny_van_Eekelen For the record, the problem was caused by an accidental circular reference in one of the formulas in column E.
Hi.
Columns C & D are just inputted numbers. Column E is D - C to calculate the difference. I have managed to get a true calculation using =SUMIF(B2:B82,"Golf Green Hall",E2:E82). My problem is that I cannot get it to calculate using "Community Centre" as the argument!..
I am pulling my hair out lol.
Columns C & D are just inputted numbers. Column E is D - C to calculate the difference. I have managed to get a true calculation using =SUMIF(B2:B82,"Golf Green Hall",E2:E82). My problem is that I cannot get it to calculate using "Community Centre" as the argument!..
I am pulling my hair out lol.
Kybo59 Can you share a link to the file on Onedrive or similar?
Riny_van_Eekelen For the record, the problem was caused by an accidental circular reference in one of the formulas in column E.
- I can send it on outlook?
Kybo59 you can click on my name tag and send it to me via a private message.
- Done - Twice!!! lol