sumif query & countif query help

[masond3]

HI

Sorry to keep bothering you guys like this, but i am either really stupid or excel, or it 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

[ConneXionLost]

It appears you have two other threads dealing with these same formulas. If this is different, PM with an explanation and I'll delete this post, otherwise:

This is a duplicate thread and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.