The spreadsheet with more data.
Thanks
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 the icon 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.
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
Hello again,
the data between A3 and O3 has not been pulled. Am i doing something wrong?
I suppose so.
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.
otunbah ,
Please take a few minutes to read the Forum Rules about thread titles before posting again.
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks