Text data formula

  • Thread starter Thread starter words777
  • Start date Start date
W

words777

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!!???
 
words777 said:
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!!???
Click to expand...

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
 
Back
Top