Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Count if and Sum If
"I want to do a formula which says
Countif(a7:a13,"roth",sum(g7:g13) Can I do this? ANy help really appreciated Michele |
#2
|
|||
|
|||
Hi
how about just =SUMIF(A7:A13,"roth",G7:G13) Cheers JulieD "mjh" wrote in message ... "I want to do a formula which says Countif(a7:a13,"roth",sum(g7:g13) Can I do this? ANy help really appreciated Michele |
#3
|
|||
|
|||
Thanks for your reply. I need it to count the values in G7:g13 though, not
add them up. Any ideas? Many thanks Michele "JulieD" wrote: Hi how about just =SUMIF(A7:A13,"roth",G7:G13) Cheers JulieD "mjh" wrote in message ... "I want to do a formula which says Countif(a7:a13,"roth",sum(g7:g13) Can I do this? ANy help really appreciated Michele |
#4
|
|||
|
|||
Do you mean something like...
=SUMPRODUCT(--(A7:A13="Roth"),1-ISBLANK(G7:G13)) or =SUMPRODUCT(--(A7:A13="Roth"),--(G7:G13<"")) then? mjh wrote: Thanks for your reply. I need it to count the values in G7:g13 though, not add them up. Any ideas? Many thanks Michele "JulieD" wrote: Hi how about just =SUMIF(A7:A13,"roth",G7:G13) Cheers JulieD "mjh" wrote in message ... "I want to do a formula which says Countif(a7:a13,"roth",sum(g7:g13) Can I do this? ANy help really appreciated Michele |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|