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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 07:15 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com