HP3000-L Archives

November 2004, Week 1

HP3000-L@RAVEN.UTC.EDU
Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
OT: Spreadsheet formula...
From:
Jerry Fochtman <[log in to unmask]>
Reply To:
Jerry Fochtman <[log in to unmask]>
Date:
Thu, 4 Nov 2004 07:58:40 -0600
Content-Type:
text/plain
Parts/Attachments:
text/plain (15 lines) 
Thought I'd tap into the wealth of knowledge on this list to see if someone
can help with building a formula which which is probably fairly easy but my
mind has gone blank....

I'd like to sum the cell contents in column "A", but only if  the value in
column "B"
on the same row contains a specific value.   I know I can do this with a
hidden column,
but wondered if there was another technique...

TIA!

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

ATOM RSS1 RSS2