Count Numeric totals from multiple cells and sheets

Brew

Well-known Member
Joined
Sep 29, 2003
Messages
1,569
How do I create a formula or code that will count the total numeric results
in each cell from G1022:U1036 of sheets 1,5,8,9 and 10-27, to the target range E6:S20 of sheet2. All sheets have been renamed, including sheet2.
 

Some videos you may like

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

Watch MrExcel Video

Forum statistics

Threads
1,113,861
Messages
5,544,723
Members
410,630
Latest member
JFORTH97
Top