think i need sumproduct help

[Gary Keramidas]

i have an original formula:
=SUMIF(G$24:G$360,G204,E$24:E$360)

but now i need to base it on 2 criteria, the other being if v204 is in the range
of v24:v360

this gave me the count,
=SUMPRODUCT(--(G24:G360=G204),--(V24:V360=V204))
but i need to find the sum of the 2 criteria in range e24:e360

 

[Gary Keramidas]

would this be the solution?

=SUMPRODUCT(--(G24:G360=G204),--(V24:V360=V204),E24:E360)

 

[Bob Phillips]

Yews it would, as long as both criteria have to be satisfied.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Gary Keramidas]

thanks bob, i knew you would know.

--


Gary

Yews it would, as long as both criteria have to be satisfied.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Bob Phillips]

Yeah, but you knew also, which is more important <G>

Bob

 

[Gary Keramidas]

no, i guessed right, you know.

--


Gary

Yeah, but you knew also, which is more important <G>

Bob

 

[Bob Phillips]

Not to over-extend it, but don't undermine yourself. You can only guess if
you have the info and the knowledge, and the chances of a correct guess are
increased the greater the skills are.

Bob