Morning all,
I have a set of data that is split into three columns daily. How can I sum the column totals, i.e. A3+D3+G3+J3 and B3+E3.....
I have data going back to 1995!
Thanks in advance
Morning all,
I have a set of data that is split into three columns daily. How can I sum the column totals, i.e. A3+D3+G3+J3 and B3+E3.....
I have data going back to 1995!
Thanks in advance
Last edited by m5rcc; 01-20-2009 at 06:39 AM.
Total: M3: =SUMIF($A$2:$L$2,M$2,$A3:$L3)
where M2 reads Total.
copy across to O3:P3 where O2 = "Valid" and P2 = "Invalid"
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks