UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Sumproduct with numbers and text    
 
   
taenite
post Jan 22 2004, 01:22 PM
Post #1

UtterAccess Addict
Posts: 160
From: CT
=SUMPRODUCT( (TH!$G$2:$G$426="1") +(TH!$S$2:$S$426="ATP INTERPRETATION")+(TH!$S$2:$S$426="DWG CLARIFICATION")+(TH!$S$2:$S$426="DWG INTERPRETATION")+(TH!$S$2:$S$426="MAT'L INTERPRETATION")+(TH!$S$2:$S$426="PART MARKING INTERPRETATION")+(TH!$S$2:$S$426="SPECIFICATION INTERPRETATION")+(TH!$S$2:$S$426="B.O.M. INTERPRETATION"))


alright..what is wrong with the part of the equation in red??? The answer this equation pops back is 191...which is the SAME answer as when I eliminate the part in red.

In column G there are 142 "1"s...so I shouldnt be getting an answer higher than 142.

Any help is appreciated.

Thanks so much.
Go to the top of the page
 
+
NateO
post Jan 22 2004, 03:44 PM
Post #2

Remembered
Posts: 5,055
From: Minneapolis, MN, USA
Hello, you'll want to use * operators instead of +. Also, 1 should be 1 instead of "1". Hope this helps. (IMG:http://www.utteraccess.com/forum/style_emoticons/default/smile.gif)
Go to the top of the page
 
+
NateO
post Jan 22 2004, 06:30 PM
Post #3

Remembered
Posts: 5,055
From: Minneapolis, MN, USA
To tack-on, use + for or, and * for and.

A detailed description/example of the madness to the method may be found here:

http://www.utteraccess.com/forums/showflat...p;Number=322265
Go to the top of the page
 
+
« Next Oldest · Microsoft Excel · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 20th June 2013 - 12:19 AM