Absolute Sumif

A

Anthony

Hi I am trying to do a normal 'sumif' but would like the sum to be based on
absolute values.

Any ideas greatly appreciated

Thanks
 
M

Mike H

Hi,

you probably mean this

=SUMPRODUCT((A1:A9="a")*(ABS(B1:B9)))

or may mean this

=ABS(SUMIF(A1:A9,"a",B1:B9))

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMIF Function ? 1
Can I have two conditions in a SUMIF? 5
Nesting SUMIF within SUMPRODUCT 10
SUMIF with criteria "<>" & "=" 4
SUMIF() to add cells in non-contiguous ranges? (Excel 2003) 4
Combine Sumif and Countif 3
Excel - Commission using SumIF 0
Syntax help with date calculation 1

Top