Sumif

[themax16]

Evening All,

I am trying to count the number of connections that are signed.
in this instance the total would be 15 but I am unsure how I am able to create a formula that would do this for the entire row A.

A B
1 Connections Stage
2
3 3 Signed
4 5 Proposal
3 5 Signed
4 7 Proposal
3 2 Signed

Any help would be greatly appreciated.

Regards

James

[mikerickson]

I don't see how you get 15 from the posted data.

=SUMIF(C:C,"Signed",B:B) returns 10

[VBA Noob]

I make the answer 10

try

=SUMIF(B:B,"Signed",A:A)

VBA Noob

[themax16]

thanks Guys!!!