Home 
Search 
Today's Posts 
#1




COUNTIF/SUMPRODUCT??
Hey if anyone can help it would be much appreciated!
I have a column of 6 cells which can have either A/B, C, D, E etc typed in them in any order. I need each letter/s to link directly to a particular cell if typed in any of the 6 cells. If for example D1=C and D4=D then the links to those two letters need to sum. The formula I have that doesnt work (and is probably completely wrong) is: =SUMPRODUCT(('Exec Sum'!$D$8:$D$13="A/B",'Uplifted NIA to GIA ft2'!C57,IF('Exec Sum'!$D$8:$D$13="C",'Uplifted NIA to GIA ft2'!D57,IF('Exec Sum'!$D$8:$D$13="D",'Uplifted NIA to GIA ft2'!E57,IF('Exec Sum'!$D$8:$D$13="E",'Uplifted NIA to GIA ft2'!F57,IF('Exec Sum'!$D$8:$D$13="F",'Uplifted NIA to GIA ft2'!G57,IF('Exec Sum'!$D$8:$D$13="G",'Uplifted NIA to GIA ft2'!H57,IF('Exec Sum'!$D$8:$D$13="H",'Uplifted NIA to GIA ft2'!I57,0)))))))  Peet 
#2




COUNTIF/SUMPRODUCT??
Not sure what you want to do.
Need more information. "Peta" wrote: Hey if anyone can help it would be much appreciated! I have a column of 6 cells which can have either A/B, C, D, E etc typed in them in any order. I need each letter/s to link directly to a particular cell if typed in any of the 6 cells. If for example D1=C and D4=D then the links to those two letters need to sum. The formula I have that doesnt work (and is probably completely wrong) is: =SUMPRODUCT(('Exec Sum'!$D$8:$D$13="A/B",'Uplifted NIA to GIA ft2'!C57,IF('Exec Sum'!$D$8:$D$13="C",'Uplifted NIA to GIA ft2'!D57,IF('Exec Sum'!$D$8:$D$13="D",'Uplifted NIA to GIA ft2'!E57,IF('Exec Sum'!$D$8:$D$13="E",'Uplifted NIA to GIA ft2'!F57,IF('Exec Sum'!$D$8:$D$13="F",'Uplifted NIA to GIA ft2'!G57,IF('Exec Sum'!$D$8:$D$13="G",'Uplifted NIA to GIA ft2'!H57,IF('Exec Sum'!$D$8:$D$13="H",'Uplifted NIA to GIA ft2'!I57,0)))))))  Peet 
#3




COUNTIF/SUMPRODUCT??
It is for a cost management spreadsheet to track total costs of a
construction project over time. Time taken on the project is split in to four stages and each completion stage is classed by A/B, C, D, E etc. These letters need to be entered in to either of the four stages (time)(a matrix type setup), and as soon as a letter is factored in, it needs to automatically link the cost information from for example 'C' stage of project, from another sheet (projected costs) and add them in to the running total work sheet. It also needs to ignore the blank cells that are yet to have letters entered. Does this help? Thanks for looking  Peet "Sheeloo" wrote: Not sure what you want to do. Need more information. "Peta" wrote: Hey if anyone can help it would be much appreciated! I have a column of 6 cells which can have either A/B, C, D, E etc typed in them in any order. I need each letter/s to link directly to a particular cell if typed in any of the 6 cells. If for example D1=C and D4=D then the links to those two letters need to sum. The formula I have that doesnt work (and is probably completely wrong) is: =SUMPRODUCT(('Exec Sum'!$D$8:$D$13="A/B",'Uplifted NIA to GIA ft2'!C57,IF('Exec Sum'!$D$8:$D$13="C",'Uplifted NIA to GIA ft2'!D57,IF('Exec Sum'!$D$8:$D$13="D",'Uplifted NIA to GIA ft2'!E57,IF('Exec Sum'!$D$8:$D$13="E",'Uplifted NIA to GIA ft2'!F57,IF('Exec Sum'!$D$8:$D$13="F",'Uplifted NIA to GIA ft2'!G57,IF('Exec Sum'!$D$8:$D$13="G",'Uplifted NIA to GIA ft2'!H57,IF('Exec Sum'!$D$8:$D$13="H",'Uplifted NIA to GIA ft2'!I57,0)))))))  Peet 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
Sumproduct vs countif  Excel Worksheet Functions  
sumproduct or countif  Excel Discussion (Misc queries)  
COUNTIF or SUMPRODUCT  Excel Discussion (Misc queries)  
Sumproduct,Countif, I don't Know!!!!!  Excel Worksheet Functions  
countif, sumproduct  New Users to Excel 