Countif Query & sumif query help

hi

Sorry to keep bothering you guys like this, but i am either really stupid or excel doesn’t want to play ball. And i am thinking it’s the first option!

Okay i would like a countif function and also a sumif function

i have created hundreds of them today however this one doesn’t seem to work

sumif formula
Look at column A, if its Zoë Parry, look at column C. If column c = inbound enquiry, look at column D. If column D= docs out , look at column AB. If its = Close opportunity, look at column W and give me a grand sum

This should give tcv total of how many docs been sent out under each lead source which relates to the different stages .if i do this manually i can see that the value is £30855


countif formula
look at column A if its zoe parry, look at column C. If column c = inbound enquiry, look at column D. If column D= docs out , look at column AB. If its = Close opportunity
This should give me a total of how many docs been sent out under each lead source which relates to the different stages

if i do this manually i can see that there is 39records for this

if this is confusing I am sorry

i have created the chart on row AO

Which may give u a better understanding of what i am trying to achieve

please find a copy of my spreadsheet