How to apply sumproduct formula
Closed
shankar
-
6 Sep 2010 à 01:55
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 9 Sep 2010 à 01:30
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 9 Sep 2010 à 01:30
Related:
- How to apply sumproduct formula
- Apply the moderate effect smartart style - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- How to apply at the rate in laptop - Guide
- Formula to calculate vat in excel - Guide
- Spreadsheet formula - Guide
5 responses
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
6 Sep 2010 à 06:07
6 Sep 2010 à 06:07
try this on an empty cell in sheet2
=SUMPRODUCT((Sheet1!$C$2:$C$65536=C13)*(Sheet1!$G$2:$G$65536="IN")*Sheet1!$P$2:$P$65536)
here remember that c13 is in sheet2
=SUMPRODUCT((Sheet1!$C$2:$C$65536=C13)*(Sheet1!$G$2:$G$65536="IN")*Sheet1!$P$2:$P$65536)
here remember that c13 is in sheet2
k thank u , but i need to know apply this formula by changing the c13 to c14 and c15 and so on . so, that my resulted values will appear in the cell by cell
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
8 Sep 2010 à 06:42
8 Sep 2010 à 06:42
use this formula in any empty cell and copy DOWN(REPEAT DOWN-not across)
=SUMPRODUCT((Sheet1!$C$2:$C$65536=OFFSET($C$13,ROW(A1)-1,0,1,1))*(Sheet1!$G$2:$G$65536="IN")*Sheet1!$P$2:$P$65536)
=SUMPRODUCT((Sheet1!$C$2:$C$65536=OFFSET($C$13,ROW(A1)-1,0,1,1))*(Sheet1!$G$2:$G$65536="IN")*Sheet1!$P$2:$P$65536)
thank u for ur valuable suggestioin but,
i need a macro to be return so, that i can avoid writing formula repeatedly
i need a macro to be return so, that i can avoid writing formula repeatedly
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
9 Sep 2010 à 01:30
9 Sep 2010 à 01:30
shanker
you need not repeat the formula . as I told you you just copy the formulat DOWN. SEE THE MESSAGE AGAIN. The offsets function within the formula will change it c14,c15 c16 etc. In your first message you wanted "how to apply the formula"
try on this line and if still want a macro post back.
you need not repeat the formula . as I told you you just copy the formulat DOWN. SEE THE MESSAGE AGAIN. The offsets function within the formula will change it c14,c15 c16 etc. In your first message you wanted "how to apply the formula"
try on this line and if still want a macro post back.
