On 01/12/2017 21:57, T. R. Valentine wrote:
I messed up. Should be:
Thank you for the correction. The formula, with a little amendment works
flawlessly.
=SUMIFS($D$7:$D$1000,$C$7:$C$1000,"=Sold",$D$7:$D$1000,"<0")
With this formula I can now search for a certain string in column C and
SUM
I messed up. Should be:
Assuming labels are in A1:A30, values in B1:B30
=SUMIFS(B1:B30,A1:A30,"=",B1:B30,">0")
replace with the 'certain text string'
- unless you are looking for a text string within the contents of
the cells with text. That would be more complicated. I'd go for a (if
On 1 December 2017 at 13:25, Hylton Conacher (ZR1HPC)
wrote:
> I have two adjacent columns where the first contains text and the second
> contains 9 digit numbers both above and below zero.
>
> I would like to SUM the contents of the second column provided it meets two
Hi,
I have two adjacent columns where the first contains text and the
second contains 9 digit numbers both above and below zero.
I would like to SUM the contents of the second column provided it meets
two criteria, namely that the first column contains a certain text
string and the number