Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Text data formula
I need some help, I'm very new to excel and I'm having a hard time making my
spreedsheet work like I want it to...This is what i'm doing, I have Three columns, column A is labeled site with drop downs (Daksh, Tampa, Texas),column B has drop downs (Full verifications,Streamline Verifications, column C is labeled completed and I put a 1 everytime I complete a test. I then have the total of streamline verifications added up and inputed into a column D cell, and full goes into column e cell. What I want is to have all the Daksh entries that are full verifications go into column F and all the Tampa Full Verifications to go into Column G Cell. I've been working on this all day and I can't seem to seperate the totals can anyone help!!??? -- Thanks for your help, Words777 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Text data formula
"words777" wrote: I need some help, I'm very new to excel and I'm having a hard time making my spreedsheet work like I want it to...This is what i'm doing, I have Three columns, column A is labeled site with drop downs (Daksh, Tampa, Texas),column B has drop downs (Full verifications,Streamline Verifications, column C is labeled completed and I put a 1 everytime I complete a test. I then have the total of streamline verifications added up and inputed into a column D cell, and full goes into column e cell. What I want is to have all the Daksh entries that are full verifications go into column F and all the Tampa Full Verifications to go into Column G Cell. I've been working on this all day and I can't seem to seperate the totals can anyone help!!??? -- Thanks for your help, Words777 F2:=sumproduct(--($A$2:$A$5000="Daksh"),--($B$2:$B$5000+"Full Verifications")*($C$2:$C%5000)) Copy to G2 and change ($A$2:$A$5000="Daksh") to ($A$2:$A$5000="Tampa") Regards Peter |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Text data formula
Thanks so much, was able to get to do exactly what I needed.
-- Thanks for your help, Words777 "words777" wrote: I need some help, I'm very new to excel and I'm having a hard time making my spreedsheet work like I want it to...This is what i'm doing, I have Three columns, column A is labeled site with drop downs (Daksh, Tampa, Texas),column B has drop downs (Full verifications,Streamline Verifications, column C is labeled completed and I put a 1 everytime I complete a test. I then have the total of streamline verifications added up and inputed into a column D cell, and full goes into column e cell. What I want is to have all the Daksh entries that are full verifications go into column F and all the Tampa Full Verifications to go into Column G Cell. I've been working on this all day and I can't seem to seperate the totals can anyone help!!??? -- Thanks for your help, Words777 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Permanently merge cells with text data w/o a formula? | Excel Discussion (Misc queries) | |||
Data Validation for text only formula | Excel Discussion (Misc queries) | |||
Help! Formula that can Ref. hidden data & Populate Cells with desired text | Excel Worksheet Functions | |||
How do I formula a percentage with text values in the data field | Excel Worksheet Functions | |||
Using text and data in formula. | Excel Worksheet Functions |