All,
I'm attempting to count numbers in cells d9:d13 only if a number occurs to the left of it.
Please refer to spreadsheet.
Thanks in advance.
All,
I'm attempting to count numbers in cells d9:d13 only if a number occurs to the left of it.
Please refer to spreadsheet.
Thanks in advance.
Last edited by VBA Noob; 08-29-2008 at 12:55 PM.
Does this help
VBA Noob=SUMPRODUCT((D9:D12<>"")*(E9:E12<>""))
_________________________________________
![]()
![]()
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
Perfect!
Thank you, sir!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks