COUNTIF with criteria in 2 columns
=SUMIF(B$5:B$317,"Jones",C$5:C$317)
--
---
HTH
Bob
(change the xxxx to gmail if mailing direct)
"EJ" wrote in message
...
Ignore me.... I've worked it out with SUMPRODUCT!
What I do need to know is a similar thing.
I've been using =SUMIF(C$5:C$317,"0.5") - column C can contain any value
between 1 and 50 and I need the sum, but I only need it to use this if
cells
in column B meet a particular criteria, as per my previous question.
Thanks
|