worksheet function

  • Thread starter Thread starter Kelly
  • Start date Start date
K

Kelly

I need a formula that will sum if it meets two different
criteria.
Sheet 1
A B C
1. 312 402 5
2. 312 403 6
5. 312 402 7


If A:A=312 and B:B=402 then sum C:C. Which would = 12
 
=SUMPRODUCT((A1:A100=312)*(B1:B100=402),(C1:C100))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Try this:

=SUMPRODUCT((A1:A65000=312)*(B1:B65000=402)*C1:C65000)

With this function, entire columns are not valid.
 
If B:B contains other numbers such as 404 and 405 could I
have c:c sum if B:B= 402 and 403 while A:A =312?
 
Back
Top