Summing Data based upon a condition
Hi,
Let's assume you want to sum column B if column A equals customer "A"
=sumproduct(--($A$1:$A$1000="A"),$B$1:$B$1000)
"Chris" wrote:
Hi,
Trying to "Sum" data in one column (A) based upon a condition in another
column (B)....... Any help?
--
Chris
|