Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SumIf query ...
Does this function ignore invisible cells (autofilter) ? If not, what could be an alternative? -- muchacho ------------------------------------------------------------------------ muchacho's Profile: http://www.excelforum.com/member.php...o&userid=35082 View this thread: http://www.excelforum.com/showthread...hreadid=555662 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SumIf query ...
use subtotal(9,range)
on the sunif to ignore hides rows HTH regards from Brazil Marcelo "muchacho" escreveu: Does this function ignore invisible cells (autofilter) ? If not, what could be an alternative? -- muchacho ------------------------------------------------------------------------ muchacho's Profile: http://www.excelforum.com/member.php...o&userid=35082 View this thread: http://www.excelforum.com/showthread...hreadid=555662 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SumIf query ...
SORRY IT'S DOESN'T WORK
MARCELO "Marcelo" escreveu: use subtotal(9,range) on the sunif to ignore hides rows HTH regards from Brazil Marcelo "muchacho" escreveu: Does this function ignore invisible cells (autofilter) ? If not, what could be an alternative? -- muchacho ------------------------------------------------------------------------ muchacho's Profile: http://www.excelforum.com/member.php...o&userid=35082 View this thread: http://www.excelforum.com/showthread...hreadid=555662 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SumIf query ...
what makes you think it doesn't?
-- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "Marcelo" wrote in message ... SORRY IT'S DOESN'T WORK MARCELO "Marcelo" escreveu: use subtotal(9,range) on the sunif to ignore hides rows HTH regards from Brazil Marcelo "muchacho" escreveu: Does this function ignore invisible cells (autofilter) ? If not, what could be an alternative? -- muchacho ------------------------------------------------------------------------ muchacho's Profile: http://www.excelforum.com/member.php...o&userid=35082 View this thread: http://www.excelforum.com/showthread...hreadid=555662 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SumIf query ...
Hi Bob,
I have type without test, and when I have tried it doesn't work here, course I did something bad, if you say it works. It works. Regards and thanks for the feedback Marcelo "Bob Phillips" escreveu: what makes you think it doesn't? -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "Marcelo" wrote in message ... SORRY IT'S DOESN'T WORK MARCELO "Marcelo" escreveu: use subtotal(9,range) on the sunif to ignore hides rows HTH regards from Brazil Marcelo "muchacho" escreveu: Does this function ignore invisible cells (autofilter) ? If not, what could be an alternative? -- muchacho ------------------------------------------------------------------------ muchacho's Profile: http://www.excelforum.com/member.php...o&userid=35082 View this thread: http://www.excelforum.com/showthread...hreadid=555662 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SumIf query ...
Surely I need an IF statement though. What I want is for it to add some numbers up but only if the cell equals X. For example ... Position - Value 2 - 33 2 - 44 4 - 66 5 - 33 6 - 22 So here I would like to display the total of position 2. Which would be 33+44. I use autofilter so I only want it to work with the numbers in view. I'm wondering what I would use to have the SubTotal mixed with an IF statement. -- muchacho ------------------------------------------------------------------------ muchacho's Profile: http://www.excelforum.com/member.php...o&userid=35082 View this thread: http://www.excelforum.com/showthread...hreadid=555662 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SumIf query ...
=subtotal(9,range)
HTH regards Marcelo "muchacho" escreveu: Surely I need an IF statement though. What I want is for it to add some numbers up but only if the cell equals X. For example ... Position - Value 2 - 33 2 - 44 4 - 66 5 - 33 6 - 22 So here I would like to display the total of position 2. Which would be 33+44. I use autofilter so I only want it to work with the numbers in view. I'm wondering what I would use to have the SubTotal mixed with an IF statement. -- muchacho ------------------------------------------------------------------------ muchacho's Profile: http://www.excelforum.com/member.php...o&userid=35082 View this thread: http://www.excelforum.com/showthread...hreadid=555662 |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SumIf query ...
That is different, introducing a condition.
Try this =SUMPRODUCT(SUBTOTAL(9,OFFSET($B$1,ROW($B$1:$B$200 )-ROW($B$1),,1))*(A1:A200= "X")) -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "muchacho" wrote in message ... Surely I need an IF statement though. What I want is for it to add some numbers up but only if the cell equals X. For example ... Position - Value 2 - 33 2 - 44 4 - 66 5 - 33 6 - 22 So here I would like to display the total of position 2. Which would be 33+44. I use autofilter so I only want it to work with the numbers in view. I'm wondering what I would use to have the SubTotal mixed with an IF statement. -- muchacho ------------------------------------------------------------------------ muchacho's Profile: http://www.excelforum.com/member.php...o&userid=35082 View this thread: http://www.excelforum.com/showthread...hreadid=555662 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problems importing from an Access query | Excel Discussion (Misc queries) | |||
changing query source | Excel Worksheet Functions | |||
enable automatic refresh | Excel Worksheet Functions | |||
AHHH! Again | Excel Discussion (Misc queries) | |||
AHHHH-Get Data from Multiple Excel workbooks | Excel Discussion (Misc queries) |