Hi there-
I have a formula that works perfectly fine with normal ranges. I've decided to add dynamic ranges so I don't have to manually update them when I paste the new data into the worksheet. However, since converting them, my formula doesn't work. If I convert one of them to a normal range...
Hi Deb -
It is similar, but a different solution (I put that in my first post of this thread). I didn't want to piggy back onto that post, as this is a different request. If mods prefer that I'd have added onto the previous post, then going forward I will do that.
Thanks!
Shrivallabha
If I wanted to add one more criteria to this would it look like this?
=SUMPRODUCT((ISNUMBER(SEARCH(A23,Theme_All,1))*1)*(DDR="Care:R1")*1)
Where DDR is another criteria, and 'Care:R1' is one of 5 values.
Thanks!
Greetings-
Similar question I asked here : http://chandoo.org/forums/topic/sumproduct-question-2
I've got a list of 7 items (A2:A8). On another sheet, I have cells that have multiple combinations of these 7 items. I basically need to count the number of occurences of each item. Data looks...
if you google Indirect, Contextures has an excellent tutorial on this exact topic. In fact, some of the examples even use your similar criteria.
http://www.contextures.com/xlFunctions05.html#DataVal
SUMPRODUCT is a pretty awesome way to do this. There are a LOT of posts around this approach. Search in the google search under SUMPRODUCT. Chandoo even has some excellent blog posts and examples!
I'm learning more and more SUMPRODUCT is my best friend a lot of times!
Much appreciated guys. My data was as follows:
A | B
Status | Packages
Approved | Firewall, Consulting Services
Approved | Software, Firewall, Consulting Services
Submitted | Software,Consulting Services
Pending |...
HI there-
I have the following formula:
=SUMPRODUCT(([@Status]="Approved")*(([@[System Solution]]=FIND("Software",[@[System Solution]],1))))
It's working, as I'm getting "VALUE" for those that do not have the value "Software" in the System Solution column, and a "0" for the ones that do...
Not an Excel expert by any means myself (which is why I'm here too :-)), but, most of my comments are around the appearance.
I'd suggest adding some titles to your charts & the dashboard itself (Student what?) so the viewer knows what they're looking at. Also, some borders around the entire...
If you search like bobhc said, there are plenty of examples of simple dashboards. The first result is every post Chandoo has done about dashboards. If you look through them you will find his simple dashboard approach, as well as detailed steps on how to create them.
In fact, the google search...
Can another option be to add the classification column. Then, simply use the text filter on the column with those key words. finally add the classification in the column, and simply copy down on the filtered items.
Just another way to possibly skin a cat.
Hi NARAYANK991 -
How could you increase the number of characters on either side? Say the list was:
Alpha 31:
Beta 1944:
Delta 323:
I understand you need to update the array of "A" "B" "C" to now include "D", but, say the numbers are now more complex.
You could always embed the index formula into an "IF" statement..something like IF(NamedRange>1,INDEX('Specs'!$B$2:$CW$69,ROW($A1),MATCH(C$7,'Specs'!$B$2:$CW$2,0)),""),
where NamedRange is $B$2:$CW$69.