Sum IF (x and Y)

[Juan]

how do I create a formula to get a SUM if two columns are
utilized, in other words, sum if AREA(columnA) is 10, and
WORK(columnb) is CONSTRUCTION...
How can you tyoe the formula...

thanks
Juan

 

[Ken Wright]

Ah, but what if he has entries where he has CONSTRUCTION in B and a number other than 10 in A. He
would get them counted as 10 well.

=SUMPRODUCT((A1:A100=10)*(B1:B100="CONSTRUCTION"))*10 will hopefully do it though

 

[Bob Phillips]

mental blockage. Knew I wasn't getting it.

Bob

Ah, but what if he has entries where he has CONSTRUCTION in B and a number other than 10 in A. He
would get them counted as 10 well.

=SUMPRODUCT((A1:A100=10)*(B1:B100="CONSTRUCTION"))*10 will hopefully do it though

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL2K & XLXP

-------------------------------------------------------------------------- --
Attitude - A little thing that makes a BIG difference
-------------------------------------------------------------------------- --