Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 30th 09, 03:05 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2009
Posts: 16
Default 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   Report Post  
Old January 30th 09, 05:10 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2008
Posts: 1,805
Default 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   Report Post  
Old January 31st 09, 08:08 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2009
Posts: 16
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sumproduct vs countif Scott Kieta[_2_] Excel Worksheet Functions 5 May 22nd 08 09:41 PM
sumproduct or countif dr350x Excel Discussion (Misc queries) 7 June 16th 07 03:27 PM
COUNTIF or SUMPRODUCT tmcook Excel Discussion (Misc queries) 1 May 7th 07 10:20 AM
Sumproduct,Countif, I don't Know!!!!! Cobbcouk Excel Worksheet Functions 4 July 27th 06 07:51 PM
countif, sumproduct mg New Users to Excel 7 July 1st 05 10:26 PM


All times are GMT +1. The time now is 11:18 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017