The spreadsheet with more data.
Thanks
Like so, pretty long for a strange layout:
=(COUNTIF($A$3:$O$3,"=H")+COUNTIF($A$3:$O$3,"=L/D")+COUNTIF($A$14:$P$14,"=H")+COUNTIF($A$14:$P$14,"=L/D"))*5
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
Okay, this looks very scary. So do i highlight the R14 and cut and paste the formular into the formular bar?
Totally..
Highlight that formula in the message above, Ctrl-C to copy it into computer memory.
Click on cell R14, then click the Formula Bar, and press Ctrl-V to copy it in, press Enter.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
If you want to be able to copy that formula up/down the R column and have it do the other sums for you, here is the adjusted formula. Paste this into R14, then copy it up or down that column.
=(COUNTIF($A3:$O3,"=H")+COUNTIF($A3:$O3,"=L/D")+COUNTIF($A14:$P14,"=H")+COUNTIF($A14:$P14,"=L/D"))*5
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
Hello again,
the data between A3 and O3 has not been pulled. Am i doing something wrong?
I suppose so.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
Hey,
Thanks for all your effort. Still not the result i expected, will continue to tweak with the hope that i get the right result.
I do hope you don't give up on it(me) though.
Regards
What result did you expect? Be specific.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
otunbah ,
Please take a few minutes to read the Forum Rules about thread titles before posting again.
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks