Previous Topic Next Topic

How to insert result of =SUMIF on next free row

Closed
DavidJones_1946 Posts 4 Registration date Sunday April 28, 2013 Status Member Last seen April 28, 2013 - Apr 28, 2013 at 05:30 AM
I want to create an =sumif query on a new tab, which looks at all 12 tabs in an annual accounts workbook, either month by month or all 12 months at once, and then inserts the results into the preformatted original tab. I'm comfortable with the =sumif function but don't know how to make the results insert into the next free rowon the tab with the query.
Related:

Similar discussions

You disagreed with the decision facebook
MDHamijuddin -
HelpiOS -

1 response
Micro sd card showing "please insert Disk"
Joreece -
meme -

6 responses
Code for macro that conditionally inserts rows
bfleming -
bfleming -

4 responses
The system time is invalid
LeonardPromise -
Jules_St-Germain -

5 responses
How to generate a STATIC unique identifier for each Excel row
Musicar -
ac3mark -

4 responses
Macro to insert row based on variable cell value (text)
deadxcell -
vcoolio -

1 response