think i need sumproduct help
 

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

think i need sumproduct help
 

would this be the solution?

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

--


Gary


"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
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

think i need sumproduct help
 

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" <GKeramidasATmsn.com wrote in message
...
would this be the solution?

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

--


Gary


"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
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

think i need sumproduct help
 

thanks bob, i knew you would know.

--


Gary


"Bob Phillips" wrote in message
...
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" <GKeramidasATmsn.com wrote in message
...
would this be the solution?

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

--


Gary


"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
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

think i need sumproduct help
 

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

Bob

"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
thanks bob, i knew you would know.

--


Gary


"Bob Phillips" wrote in message
...
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" <GKeramidasATmsn.com wrote in message
...
would this be the solution?

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

--


Gary


"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
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

think i need sumproduct help
 

no, i guessed right, you know.

--


Gary


"Bob Phillips" wrote in message
...
Yeah, but you knew also, which is more important <G

Bob

"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
thanks bob, i knew you would know.

--


Gary


"Bob Phillips" wrote in message
...
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" <GKeramidasATmsn.com wrote in message
...
would this be the solution?

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

--


Gary


"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
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

think i need sumproduct help
 

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

"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
no, i guessed right, you know.

--


Gary


"Bob Phillips" wrote in message
...
Yeah, but you knew also, which is more important <G

Bob

"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
thanks bob, i knew you would know.

--


Gary


"Bob Phillips" wrote in message
...
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" <GKeramidasATmsn.com wrote in message
...
would this be the solution?

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

--


Gary


"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
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