ExcelBanter - summing visible cells using SUMIF/SUMPRODUCT not SUBTOTAL

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - summing visible cells using SUMIF/SUMPRODUCT not SUBTOTAL (https://www.excelbanter.com/excel-discussion-misc-queries/214576-summing-visible-cells-using-sumif-sumproduct-not-subtotal.html)

EricBB

summing visible cells using SUMIF/SUMPRODUCT not SUBTOTAL

how to sum only the visible cells using SUMIF or SUMPRODUCT not SUBTOTAL

Pecoflyer[_56_]

summing visible cells using SUMIF/SUMPRODUCT not SUBTOTAL

'This site' (http://www.cpearson.com/excel/IsVisible.aspx) should get
you started

--
Pecoflyer

Cheers -
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=43943

All times are GMT +1. The time now is 08:37 PM.