Problem SUMIF formula

Hi I wonder if anyone can help me please, I'm stuck and I'm not sure what to do.

I've been asked to look at someone's spreadsheet, which has a number of worksheets.

The ones in question are all SumIF's.

Here's an example: =SUMIF(D5:D4476,D4477,L5:L4476)
Column D is a list of Category names, D4477 is a cell titled "Plant Charges from Murphy Plant"
Column L is a list of costs.

I thought, regarding Sumifs, that it would look in Col D for anything as described in D4477 and bring back the resulting costs.

But there isn't anything in column D titled Plant Charges, and there aren't any hidden columns with "plant charge".

Please can you tell me where it is pulling the numbers from?

I'm stumped. There are 8 sumif's doing pretty much the same thing on 4 other worksheets.

He wants me to explain how the sheet is coming to the conclusive figure which sum's 5 figures in total from the 5 worksheets.

But I'm stuck on the Sumif's.

I'm hoping it will be a Eureka moment when I actually see what its doing.

I'm very intrigued. Your help will be greately appreciated. I thought there might be a key worksheet or something, not that its referred to in the forumula, but its working out what are Plant Charges from somewhere.

Thank you hope somebody can shed some light on this for me.

Also there are alot of hidden rows, I thought if I selected them and then "unhide" they would appear, I even checked row height, but no joy, have had to manually double click them to make them reappear.

Clair

(not posted for a while as Ive actually been unwell, now getting back on my feet)

Could you tell me how to add an attachment please, I have used "advanced" and uploaded it, but if I click the attachment button nothing happens, I've tried using both chrome and edge.

I get the same problem.

Thank you
Clair

I've loaded the worksheet into my onedrive, it says external links have been disabled, so I'm not sure if it will be 100%

https://onedrive.live.com/edit.aspx?...!103&app=Excel

As before the main total is in O2989 which is summing the 2 above it, both curious sumif's.

Sumif(F$5:F$2986 (all text), F2987 (text but not listed in the rest of Col F), O$5:O$2986 (all figures)

As the text in F2987 is not actually listed in the Column I've no idea how it is choosing the numbers which make up the total. I'm completely stumped.

The other 3 totals I need have sumif's set up in exactly the same way. I can't see from the forumula how its selecting anything else except whats the text in F2987.

It totaly doesn't make sense. I've looked to see if perhaps the text itself has a search behind it so it selects only Plant charges (for example), but I can't see anything.

Also the first rows are hidden, is there a quick way to be able to view them please?

Thank you
Clair

OMG thank you, it now makes perfect sense