| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumproduct with Condition OR Sumproduct with ADDRESS function - HE | Excel Discussion (Misc queries) | |||
| Conditional SUMPRODUCT or SUMPRODUCT with Filters | Excel Worksheet Functions | |||
| sumproduct? sumif(sumproduct)? | Excel Worksheet Functions | |||
| hlp with sumproduct! | Excel Worksheet Functions | |||
| sumproduct help | Excel Worksheet Functions | |||
Linear Mode
