Please help. Try as I might, I cannot find a simple formula which will sum all the cells in a row which are marked "A". The next cell has to tally all the cells marked "B".
I thought this would work but it didn't:
=SUM(B2:B40="A")
Please help. Try as I might, I cannot find a simple formula which will sum all the cells in a row which are marked "A". The next cell has to tally all the cells marked "B".
I thought this would work but it didn't:
=SUM(B2:B40="A")
Perhaps:
![]()
Please Login or Register to view this content.
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