| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Running total for 2 columns IF column 3.......
Can anyone help, I am trying to keep a running total of impressions based on daily entries throughout the month: If column G = "letter" than column C (sets) * column E (pages) If column G = "tabloid" than column C (sets) * column E (pages)*2 Thank you in advance, paulab |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Running total for 2 columns IF column 3.......
=IF(G1="letter",C1*E1,IF(G1="tabloid",C1*E1*2))
On 9 Lis, 14:26, paulab wrote: Can anyone help, I am trying to keep a running total of impressions based on daily entries throughout the month: If column G = "letter" than *column C (sets) * column E (pages) If column G = "tabloid" than *column C (sets) * column E (pages)*2 Thank you in advance, paulab |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Running total for 2 columns IF column 3.......
Try the below
=SUMPRODUCT((G1:G10="letter")*C1:C10*E1:E10) =SUMPRODUCT((G1:G10="tabloid")*C1:C10*E1:E10*2) If this post helps click Yes --------------- Jacob Skaria "paulab" wrote: Can anyone help, I am trying to keep a running total of impressions based on daily entries throughout the month: If column G = "letter" than column C (sets) * column E (pages) If column G = "tabloid" than column C (sets) * column E (pages)*2 Thank you in advance, paulab |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Running total for 2 columns IF column 3.......
What happens if G does not equal either of those choices? In this formula, it
causes the result to be 0. =C2*E2*IF(G2="letter",1,IF(G2="tabloid",2,0) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "paulab" wrote: Can anyone help, I am trying to keep a running total of impressions based on daily entries throughout the month: If column G = "letter" than column C (sets) * column E (pages) If column G = "tabloid" than column C (sets) * column E (pages)*2 Thank you in advance, paulab |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Running total for 2 columns IF column 3.......
Hi,
try =IF(SUMPRODUCT((A1:A4="letter")*(B1:B4*E1:E4))0,S UMPRODUCT((A1:A4="letter")*(B1:B4*E1:E4)),IF(SUMPR ODUCT((A1:A4="tabloid")*(B1:B4*E1:E4*2))0,SUMPROD UCT((A1:A4="tabloid")*(B1:B4*E1:E4*2)))) "paulab" wrote: Can anyone help, I am trying to keep a running total of impressions based on daily entries throughout the month: If column G = "letter" than column C (sets) * column E (pages) If column G = "tabloid" than column C (sets) * column E (pages)*2 Thank you in advance, paulab |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Running total for 2 columns IF column 3.......
hI,
This formula will work better specially if you have both words in the column =SUMPRODUCT((A1:A5="tabloid")*(B1:B5*E1:E5*2))+SUM PRODUCT((A1:A5="letter")*(B1:B5*E1:E5)) "Eduardo" wrote: Hi, try =IF(SUMPRODUCT((A1:A4="letter")*(B1:B4*E1:E4))0,S UMPRODUCT((A1:A4="letter")*(B1:B4*E1:E4)),IF(SUMPR ODUCT((A1:A4="tabloid")*(B1:B4*E1:E4*2))0,SUMPROD UCT((A1:A4="tabloid")*(B1:B4*E1:E4*2)))) "paulab" wrote: Can anyone help, I am trying to keep a running total of impressions based on daily entries throughout the month: If column G = "letter" than column C (sets) * column E (pages) If column G = "tabloid" than column C (sets) * column E (pages)*2 Thank you in advance, paulab |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Running total for 2 columns IF column 3.......
Perfect!!
Thank you "Eduardo" wrote: hI, This formula will work better specially if you have both words in the column =SUMPRODUCT((A1:A5="tabloid")*(B1:B5*E1:E5*2))+SUM PRODUCT((A1:A5="letter")*(B1:B5*E1:E5)) "Eduardo" wrote: Hi, try =IF(SUMPRODUCT((A1:A4="letter")*(B1:B4*E1:E4))0,S UMPRODUCT((A1:A4="letter")*(B1:B4*E1:E4)),IF(SUMPR ODUCT((A1:A4="tabloid")*(B1:B4*E1:E4*2))0,SUMPROD UCT((A1:A4="tabloid")*(B1:B4*E1:E4*2)))) "paulab" wrote: Can anyone help, I am trying to keep a running total of impressions based on daily entries throughout the month: If column G = "letter" than column C (sets) * column E (pages) If column G = "tabloid" than column C (sets) * column E (pages)*2 Thank you in advance, paulab |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Running total for 2 columns IF column 3.......
=SUMPRODUCT((G1:G100={"letter","tabloid"})*(C1:C10 0*E1:E100)*{1,2})
"paulab" wrote: Can anyone help, I am trying to keep a running total of impressions based on daily entries throughout the month: If column G = "letter" than column C (sets) * column E (pages) If column G = "tabloid" than column C (sets) * column E (pages)*2 Thank you in advance, paulab |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there any way of calculating a running total within a single cell in a column | New Users to Excel | |||
| Running total at bottom of column? | Excel Discussion (Misc queries) | |||
| Running total w/2 columns - Excel | Excel Worksheet Functions | |||
| Running total in Excel w/2 columns | Excel Worksheet Functions | |||
| How do I Autosum a running column total in excel? | Excel Worksheet Functions | |||
Linear Mode
